-
Jet 4.0 ISAM "INSERT INTO....."
I'm looking for an explanation on this. I run a process that visits several URLS and translates Cold Fusion grids into .csv, concatenates the csv and saves it as XLS.
The next step [importing to Access] was done manually, with the import Wizard and works w/out error.
Seeking to automate that step I attempted: (pseudo-code; oConn is a Connection Object)
[vba]
oConn.Execute 'INSERT INTO [temp] SELECT * FROM [UPLOAD$] IN "" [Excel 8.0;IMEX=2;HDR=YES;DATABASE=' & cXLS & '];'
[/vba]
which gives an error, "field is too small to accept data...."
The workaround is to perform a SELECT on the data and then do a row x row insert, but that takes longer as I am dealing w/thousands of rows.
So, why the error from ADO but no error from the import wizard - same workbook, same table????? Stan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules