Importing from Text files.

[doyapore]

Dear All,
I wish to import from a text file which has records stored in fixed field
length manner.
Following are the field names and their respective lengths:
1. Code_no: 10 character.
2. Card_slno: 10 character.
3. Amount: 10 character.
After importing the relevant records, I also wish to convert the Amount
field into a numeric type data and place all the fields together in a table.

Thank you.

 

[Jeff Boyce]

Access provides tools/wizards to help you import a text file. If you will
be regularly importing data this way, consider setting up an Import
Specification, using an Import Table (to temporarily hold the import data),
and as many queries as you need to append/update your permanent data into
your (normalized) data structure.

 

[doyapore]

Thanks a ton.
May I ask another question: Where are the import specifications stored?

Thank you.

 

[Jeff Boyce]

That's a great question! I've never been able to figure out where Access
hides them away, but I know if I try to import a text file, I get a window
that lists Import/Export specs and lets me modify them.

 

[Rick Brandt]

That's a great question! I've never been able to figure out where
Access hides them away, but I know if I try to import a text file, I
get a window that lists Import/Export specs and lets me modify them.

In two system tables.

MSysIMEXSpecs
MSysIMEXColumns

 

[doyapore]

You are an ace! I found the tables after enabling the system & hidden table
view under Tools -> Options -> View. At which point, another question arises
which is as follows:
MSysIMEXSpecs stores all the different types of text import specifications
which have been saved for various text import types. However, on opening the
MSysIMEXColumns one finds that the latest text import specifications have
been detailed therein. Where are the other text import specifications
stored, then?

Thanks in advance.
Merry Christmas and Seasons Greetings


Thank you once again.

 

[Jeff Boyce]

Thanks, Rick. I knew they had to be in there somewhere, I just never went
searching for them...

Jeff Boyce