VBA *.csv Import

[BMLekki]

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

[BMLekki]

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.