Text Data Import

G

Guest

I need to simplify my work when importing text data. Every time when i import
text data i have to break line (setting column) and etc.

Is there any way that i can just built the text data spec in access table
and run some code/command to import it.

Thanks
 
G

Guest

You should look at the TransferText Method. Using it you should be able to
automate your import process completly,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access 2000 database Import Spec not working properly 1
Transfertext import from csv- want text fields but saves as number field so lose data. 5
Import .xml with a macro 4
Import Spec CSV 7
Type Conversion Error While Importing (Time Field) 8
Import text specification file 8
Access 2007: Import Text Wizard errors 4

Top