[AccessD] Transfer Text Problem

Rocky Smolin rockysmolin at bchacc.com
Mon May 24 09:45:45 CDT 2010


Dear List:

I have to import a CSV file with field names.  I did a manual import first
to get the import table created.  Problem is that one of the columns in the
CSV file has the name "P.O. Good Thru Date" and that gets created in the
table as "PO Good Thru Date".  Period is an invalid character in a field
name in an Access table.

So when I try to do the import using TransferText I get an error message
saying the field doesn't exist.  Which of course it doesn't.

The CSV file is an export from Peachtree so I don't think the user has the
option of changing the field name in the first row of the CSV file.

Is there a programmable way around this?

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 



More information about the AccessD mailing list