Import fixed width text file.

T

Tomas

I am having trouble automating the import of a fixed width txt file. I have
tried the schema.ini file but access did not let me put it in the
specification name box. Any help would be great.
 
S

Steve Schapel

Tomas,

To create a Specification, run through the process "manually" via the
File|Get External Data menu. On the last screen of the Import Wizard,
click the Advanced button, which will open a dialog where you can name
and save the specification.
 
T

Tomas

Thank you Steve. That works great.

Steve Schapel said:
Tomas,

To create a Specification, run through the process "manually" via the
File|Get External Data menu. On the last screen of the Import Wizard,
click the Advanced button, which will open a dialog where you can name
and save the specification.
Click to expand...
 

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

Mail Merge Directory Conditional Page Break 0
Synchronization problems while moving folders to new email 1
Automation of scanned file storage based on content 0
Table Preferred width is changed when pasting 1
Move Chart with Text 0
Import text file with macro - Invalid argument (Error3001) 0
Preserving trailing zeros for a fixed width file 0
VBA - (re-) Set a Table Style 2

Top