ADO. Populating MDB from CSV returns all records with null values.

J

Jeff Budden

Hi, I am a bit stuck. I have a routine that executes a sql statement similar
to

Select Field1, field2, field3 INTO tbltablename IN MDB_location from
CSV_Location

My connection string is

strCSVConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & Fpath &
"';Extended Properties='text; HDR=Yes; FMT=CSVDelimited';"

Where fPath is the CSV file path

I am quite sure my SQL syntax is good. Is it someting with the connection
string?

The CSV contains nearly 30,000 records. The Table generates and the number
of records comes over equal to the rows in the csv. However all fields for
all records are null. I confirmed this by creating an ADO recordset and
checked the recordcount and the values in recordset.fields(x).value

Thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using ADO to Read from CSV to automate Project 3
Query records from the current year, month and records with Null value 2
ADO With Text Files 1
NULLs returned from ADO query cause controls to be disabled 0
ADO Select qry to access mdb 0
Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook using ADO 2
Security Hole in ADO Connection from ADP to SQL Server 19
Getting records from Access 97 to Excel 97 3

Top