-
VBA *.csv Import
I need to be able import fixed files without field names.
the code is:
appAccess.DoCmd.TransferText acImportFixed, , "Brian", strFileName, 0
Now the problem is, vb is giving me a runtime error of "2511", "The Action or Method requires a specification Name Argument.
I see that the specification name goes between:
acImportFixed, , "Brian", but I do not know what it needs.
Thanks
-
Re: VBA *.csv Import
There is a problem with this see Microsoft.
http://support.microsoft.com/support.../Q241/4/77.ASP
Although there is a way around it, I couldn't get it to work, so i just took my colHeadName and add it a seperate file and then merged the names with the data file and then imported it...
So far no problems with it.