Importing csv file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rich - 04 Aug 2004 23:30 GMT

I'm running the following code...

DoCmd.TransferText
acImportDelim, "", "tblTEST", "C:\data.csv", True.

The problem is 2 columns are being imported as "Currency"
when the data is actually text. For example, in the csv
file, "F837250" is coverted in Access to Currency and the
Access table displays $837,250.

How do I make Access import this column as text?

thanks
Rich

Reply to this Message

Ken Snell - 05 Aug 2004 01:49 GMT

Use an Import Specification.

You set up your spec by starting to do the import manually, and when the
wizard window opens, click on the Advanced button at bottom left -- you then
can set all the export specification parameters and save the spec as
whatever name

Signature

Ken Snell
<MS ACCESS MVP>
you want. Then cancel the import and use the spec name in the
DoCmd.TransferText method:

DoCmd.TransferText acImportDelim, "ImportSpecificationName", "tblTEST",
"C:\data.csv", True.

> I'm running the following code...
>
[quoted text clipped - 10 lines]
> thanks
> Rich

Reply to this Message

- 05 Aug 2004 12:57 GMT

EXCELLENT. THANKS

>-----Original Message-----
>Use an Import Specification.
[quoted text clipped - 3 lines]
>can set all the export specification parameters and save the spec as
>whatever name

acImportDelim, "ImportSpecificationName", "tblTEST",

>"C:\data.csv", True.
>
[quoted text clipped - 14 lines]
>
>.

Reply to this Message