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/>