This may not even be possible, but can you use the "LOAD DATA LOCAL INFILE"
statement with ASP? I know it's possible with phpMyAdmin, but I'm still very
new to ASP. I've tried writing the SQL query as shown in phpMyAdmin, but I
get the error "Expected Insert, Delete, Update, or Select". If that command
is not possible, is there another way to load a file into an MS Access
database via asp?

Any and all help is greatly appreciated.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

ahhahahahahahahahahahahhaa

tadinuxxxxxxxxxx delexxxxxxxxxxx

----- Original Message -----
From: Young, Ashley <Ashley.Young@c...>
To: Access ASP <access_asp@p...>
Sent: Tuesday, August 13, 2002 11:39 AM
Subject: [access_asp] Using LOAD DATA LOCAL with ASP


> This may not even be possible, but can you use the "LOAD DATA LOCAL
INFILE"
> statement with ASP? I know it's possible with phpMyAdmin, but I'm still
very
> new to ASP. I've tried writing the SQL query as shown in phpMyAdmin, but I
> get the error "Expected Insert, Delete, Update, or Select". If that
command
> is not possible, is there another way to load a file into an MS Access
> database via asp?
>
> Any and all help is greatly appreciated.
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
>
>
>

Gee, Daniel, thanks for that.

-----Original Message-----
From: Daniel Groh [mailto:daniel.groh@s...]
Sent: Tuesday, August 13, 2002 9:51 AM
To: Access ASP
Subject: [access_asp] Re: Using LOAD DATA LOCAL with ASP


ahhahahahahahahahahahahhaa

tadinuxxxxxxxxxx delexxxxxxxxxxx

----- Original Message -----
From: Young, Ashley <Ashley.Young@c...>
To: Access ASP <access_asp@p...>
Sent: Tuesday, August 13, 2002 11:39 AM
Subject: [access_asp] Using LOAD DATA LOCAL with ASP


> This may not even be possible, but can you use the "LOAD DATA LOCAL
INFILE"
> statement with ASP? I know it's possible with phpMyAdmin, but I'm still
very
> new to ASP. I've tried writing the SQL query as shown in phpMyAdmin, but I
> get the error "Expected Insert, Delete, Update, or Select". If that
command
> is not possible, is there another way to load a file into an MS Access
> database via asp?
>
> Any and all help is greatly appreciated.
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
>
>
>



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
 

Hey, you can make that:

<%
response.buffer = true  'it stores the information in buffer
%>

and where you would want to load, make that:

<%
response.flush
%>

well, It was what I understood

Cya

----- Original Message ----- 
From: Young, Ashley <Ashley.Young@c...>
To: Access ASP <access_asp@p...>
Sent: Tuesday, August 13, 2002 11:39 AM
Subject: [access_asp] Using LOAD DATA LOCAL with ASP


> This may not even be possible, but can you use the "LOAD DATA LOCAL INFILE"
> statement with ASP? I know it's possible with phpMyAdmin, but I'm still very
> new to ASP. I've tried writing the SQL query as shown in phpMyAdmin, but I
> get the error "Expected Insert, Delete, Update, or Select". If that command
> is not possible, is there another way to load a file into an MS Access
> database via asp?
> 
> Any and all help is greatly appreciated.
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.377 / Virus Database: 211 - Release Date: 7/15/2002
>  
> 
> 

a) ASP is a scripting environment, not a language. So there is no answer to
the question "can I use the following statement: xyz"? because it depends on
what language you are using (PerlScript, VBScript, JScript etc)

b) To manipulate data in a database you use SQL (Structured Query Language),
you do not use VBScript or PHP or any other language. SQL is what is called
a DDL/DML (Data Definition Language/Data Modification Language) and is used
for manipulating both the structure of a database, and the data it contains.
Every major relational database (Access, Oracle, mySQL, DB2, MS SQL Server)
supports SQL.

c) SQL has statements like INSERT, UPDATE, DELETE etc for manipulating data.
Perhaps if you could explain where the data is coming from (a text file? a
webpage? another database?) we could help you write the necessary SQL to
send to the database to do what you want.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Young, Ashley" <Ashley.Young@c...>
Subject: [access_asp] Using LOAD DATA LOCAL with ASP


: This may not even be possible, but can you use the "LOAD DATA LOCAL
INFILE"
: statement with ASP? I know it's possible with phpMyAdmin, but I'm still
very
: new to ASP. I've tried writing the SQL query as shown in phpMyAdmin, but I
: get the error "Expected Insert, Delete, Update, or Select". If that
command
: is not possible, is there another way to load a file into an MS Access
: database via asp?
:
: Any and all help is greatly appreciated.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~