batch upload

P

pillmill

What is a simple method to
implement a batch upload of
a csv file to an Access table ?

Thanks,
Phil
 
D

David Lloyd

Select Export from the File menu. In the Save as Type drop down, select
Text Files. Select delimited in the export wizard and follow the options.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


What is a simple method to
implement a batch upload of
a csv file to an Access table ?

Thanks,
Phil
 
D

David Lloyd

That was for an export of course. To import, go to the File menu, select
Get External Data and Import. In the Files of Type drop down, select Text
Files and then proceed as previously discussed.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Select Export from the File menu. In the Save as Type drop down, select
Text Files. Select delimited in the export wizard and follow the options.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


What is a simple method to
implement a batch upload of
a csv file to an Access table ?

Thanks,
Phil
 
P

pillmill

Hi David:

Could you suggest a
way to do this
using VB code attached
to a form ?

Thanks,
Phil
 
D

David Lloyd

Phil:

Look at using the TransferText method. Normally, you create an import
specification through the Import Text wizard accessed through the
instructions given in my last post (by clicking on the Advanced button).
You can use the Save As option to give the specification a name, which you
can then use in the TransferText method. For example:

DoCmd.TransferText acImportDelim, "MySpecificationName", "MyTableName",
"C:\MyCSVFileName.txt", False

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi David:

Could you suggest a
way to do this
using VB code attached
to a form ?

Thanks,
Phil
 
P

pillmill

Thanks David:

Now, I keep getting the error message:

"field F1 doesn't exist in the Access table"

This happens the second time I ran the upload.
There is only one field that I specified in the
source and the destination tables.

Any ideas ?

Thanks,
Phil Miller
 
P

pillmill

I can import data successfully using the import
wizard. When I save the Test Link Specification and call
it in code using the identical text file, the data does
not get written in the table and there is no error message -

DoCmd.TransferText acImportDelim, "Test Link Specification", "table3",
"C:\test\test.txt", False

Any help would be appreciated.

Phil Miller
 
Top