How do I import a csv file with spaces in Line 1, the field names

[JeffGrant]

Hi All,



I have been trying unsuccessfully to import csv files where Line 1 are the field names, but there are spaces in the names.

If I wrap the field names in quotes, no problem, but the issue is that the csv files are delivered to me everyday and changing the structure from the supplier is not really a possibility.

Currently I use PQ in Excel to massage the data, but the data is now getting to big and so PQ isn't going to cope for much longer.

I don't really want to change the csv data structure anyway because there are several data types in the file and and I dont want them to all be set as being short text.

All suggestions are graciously received.

Thanks in advance

[CJ_London]

how are you trying to import? copy/paste? import function on ribbon? transfertext in vba?

[mike60smart]

Hi Jeff

I would create a Macro in Excel which removes any spaces in Field names prior to carrying out the Import

[ssanfu]

I use code to process my test files. I used code examples site create my import routine. The csv files I imported (once a month) sometimes had over 3,000 lines in them.

I wrote code to select the text file to be imported (using the File System Object), then read each line from the text file and processed it - removes spaces, did calculations, wrote it to the new record.
Or you can pick the file, use "DoCmd.TransferText" (with an Import Specification) to copy the data to a temp table (the data is temporary, not the table), then copy the data the the final table(s) using queries or code.


Does the csv file name change every day??

[CJ_London]

OP has started a new thread on the same subject here https://www.accessforums.net/showthr...584#post485584