Import text file without field names or specification

[mims]

Hi,

Does anyone know how to import a text file into a table that does not have field names and without a specificiation?

The reason I ask is because I need to import many text files and I do not want to create a new specification for each file name.

Any help would be appreciated.

Thanks!

 

[gemma-the-husky]

whrn you import a text file, one of the options is "has field names" - ie treat the first row as field names, or not.

if not, then either import to an existing table with pre-defined names, or import to a new table, and get default names field1, fiedld2, field3 etc etc

 

[mims]

Thanks for this, but unfortuantely when i do this an error message is shown as "F1 doesnt exist". any idea how to overcome this?

 

[gemma-the-husky]

are you importing a text file or a spreadsheet?

are you sure you you have the "has field names" set to false?

--------
try it manually, to see

 

[mims]

Hi,
Yes i have set the field names to 'False', but it is still not accepting the file.

I have also tried using a schema file, but i seem to be getting the same error message.

I wouldnt have thought importing a tab delimited text file with no field names would have been such an issue??

Any help appreciated!

 

[monicaj705]

I am trying load a text file via a macro. I created an import spec and have identified it in the Specification Name field. When I run the macro, I get an error message stating the Text File Specification 1 does not exisit. I'm using Access 2010. Can anyone help?