To: CF-Talk
Sent: Fri Jun 08 16:57:26 2007
Subject: Re: Reading/Importing Large Text Files into a Database
BCP or Bulk Insert - using a DTS Package
On 6/7/07, Pete Ruckelshaus [EMAIL PROTECTED] wrote:
I had a similar problem to solve once. What I did was create a macro that
imported the data
BCP or Bulk Insert - using a DTS Package
On 6/7/07, Pete Ruckelshaus [EMAIL PROTECTED] wrote:
I had a similar problem to solve once. What I did was create a macro that
imported the data into an Access database. I set up a DSN for that access
database with a predefined file name, and gave
On 6/7/07, Roxie R [EMAIL PROTECTED] wrote:
Basically each file is a comma delimited text file that on every line has
information that needs to be checked against the database and then either
updated or inserted.
Right now I loop through every line in the file and using CFQUERY to do the
-Talk
Subject: Re: Reading/Importing Large Text Files into a Database
On 6/7/07, Roxie R [EMAIL PROTECTED] wrote:
Basically each file is a comma delimited text file that on every line has
information that needs to be checked against the database and then either
updated or inserted.
Right now I loop
I have been having this ongoing battle with large files (3 MB or more).
Basically each file is a comma delimited text file that on every line
has information that needs to be checked against the database and then
either updated or inserted.
Right now I loop through every line in the
So trying to access the file via SQL Server 2000 probably isn't possible.
Unfortunately that probably cuts out your best route, I import a fairly
substantial amount of log data into my application from CSV files and I used
a query/stored proc and the BULK INSERT function from SQL, it's very good
I had a similar problem to solve once. What I did was create a macro that
imported the data into an Access database. I set up a DSN for that access
database with a predefined file name, and gave the end user an interface to
upload their identically named Access database (the data structure was
7 matches
Mail list logo