Import csv and dots

Topic

New Reply

Hello.
(Access 2007)
I’m importing a csv where the first row has field names containing dots (periods .). So I make this the first row of the data
and then manually create these as the field names – having removed the dots.
Has anyone a procedure that could automate this re-naming of the fields? Thanks, Andy.

Reply | Quote

Replies

Andy,

When you have a cvs file with the first row has field names containing dots, like this :

you may import the file with the import wizard. The wizard will remove the dots. Like this result :
[

Reply | Quote

If you want to import it by code, you can, but you have to use Import Specifications. A line like this :

DoCmd.TransferText acImportDelim, “Book1ImportSpecifications”, “Book1”, “D:Book1.csv”, True

Reply | Quote