By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Asking for assistance

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
It is possilbe to write a vba or a macro to automate this process. I have
written VBA routines that will search the hard drive to find specific files
or file strings *.txt or what was needed by the client.
--
Dean Covey
www.coveyaccounting.com

MS-Office Certified:
http://www.microsoft.com/learning/mc...st/default.asp

"Methven" <me*****@indigo.ie> wrote in message
news:cr******************@news.indigo.ie...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.