[AccessD] Transfer Text Problem

Gary Kjos garykjos at gmail.com
Mon May 24 10:26:50 CDT 2010


Open the file as text and read correct the first record to any field
name you want and then write it back out before importing.

See Seth Galitzer's FIle IO code here

http://seth.galitzer.net/files/download/file_io.txt

GK

On Mon, May 24, 2010 at 9:45 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:
> 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/>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>



-- 
Gary Kjos
garykjos at gmail.com




More information about the AccessD mailing list