Asking for Assistance

M

Methven

Hello Folks,

I am having a small problem and I wonder if someone might be able to assist
me.

It is with the Importing of Text files into MS-Access 2000.
It is specifically with the Importing of Text files using a defined
specification.

WHAT I DO :

1. Select FILE - GET EXTERNAL DATA - IMPORT ...
2. Navigate to the correct TextFile and click on the Import Button
3. When the Import Text Wizard launches, I click on the Advanced ... button
in the bottom left-hand corner
4. I now fill in the required specifications for the importing of the
textfile

So far so good ...

As soon as I click on the Save As... button, my changes are discarded.

I have tried this on differing hardware and under differing OS.

What am I missing ?

Thank you in advance,

Michas
 
J

Joe Fallon

I do steps 1-2.
For step 3 I use the wizard and fill it out until I get to the last page.
Then I click Advanced and Save As and give the spec a name.

Then in the future I can re-use the spec manually or in code
(DoCmd.TransferText)
 

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

Top