Importing from Text files.

  • Thread starter Thread starter doyapore
  • Start date Start date
D

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.
 
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.
 
Thanks a ton.
May I ask another question: Where are the import specifications stored?

Thank you.
 
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.
 
Jeff said:
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.
Click to expand...

In two system tables.

MSysIMEXSpecs
MSysIMEXColumns
 
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.
 
Thanks, Rick. I knew they had to be in there somewhere, I just never went
searching for them...

Jeff Boyce
 
Back
Top