to convert txt file into tables

[vandana]

to convert txt file into tables

 

[HiTechCoach]

see:

importing multiple text files as one table

 

[Ziggy1]

look HERE

I have a working example, if you get stuck. You need to change the code from XLS to TXT and transferspreadsheet to transfertext. also when importing a Text file you need to create an import SPEC. When you manually import with the wizard, click the advanced tab and SAVE the spec. You need to use the name in the Docmd eg...


DoCmd.TransferText acImportDelim, "ImportSpecName", "tbltoImportTO", filenameVariable, False, ""

If you have trouble, post a sample Text file with sample data, but in the proper layout and I will set it up for you.

 

[Simon_MT]

I alwats put these text files into a spreadsheet first and once that is sorted out (data integrity) I import this into a database. I don't like rubbish in my database.


Simon

 

[Ziggy1]

I alwats put these text files into a spreadsheet first and once that is sorted out (data integrity) I import this into a database. I don't like rubbish in my database.


Simon

that's fine if you only have to do it once in a while, but that is why you can save a Specification template in the Access wizard. Once you have defined the data types, it will work seamlessly in an automated process.

 

[Simon_MT]

I've encountered so many errors in the pass it was eventually more efficient, but if it works straight into Access then use the fully automated process.

Simoin

 

[krishan.chawla]

HI...

I want to know how can i delete import/export specifications in access 2003.

It is very urget. Please guide me.

 

[Ziggy1]

HI...

I want to know how can i delete import/export specifications in access 2003.

It is very urget. Please guide me.

Not sure why it is urgent, either you use them or you don't....I think there is another way to bring up the dialogue, but this is how I do it:

Start to Import a text file ( you won't complete the import), when you get the import wizard, click the advanced button...here you will see the list of Spec files ( click the Spec button)....there you can delete them