General discussion

Locked

IMPORT & FORMAT OF TEXT FILES

By iaoi ·
HOW DO I AUTOMATE TEXT FILE IMPORTING AND FORMATTING IN MS-EXCEL OR MS-ACCESS. I TEND TO GET TIRED MANUALLY DROPPING OR PROPERLY SPACING DATA.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

IMPORT & FORMAT OF TEXT FILES

by MtnSqs In reply to IMPORT & FORMAT OF TEXT F ...

How are your test file sbeing generated?? If they are generated by another packeage then try to use a CSV (comma separated format)and save as .csv then Excel will read it in easily and automatically.

Collapse -

IMPORT & FORMAT OF TEXT FILES

by Shanghai Sam In reply to IMPORT & FORMAT OF TEXT F ...

The text files or reports I use are system generated with a .PRT extension which I format and represent according to user specifications. The system has a report writer which allows for specific file output. But thanks, I'll try renaming the latter reports with a .csv extension, and come up with VB code to read the file and format properly.

Any other ideas would be most appreciated.

Collapse -

IMPORT & FORMAT OF TEXT FILES

by Miss Kitty In reply to IMPORT & FORMAT OF TEXT F ...

In Access you can write a macro to import your text file in and use a specification to assign what fields are what type. To set up a specification:
1. When you import a file, before you click on finish, click on advanced.
2. Set your fields to the format you want to import them to.
3. Save your specification.
You can set your macro to open when you open the database and this should take care of you
having to manipulate the format in ACCESS.
Good Luck

Collapse -

IMPORT & FORMAT OF TEXT FILES

by iaoi In reply to IMPORT & FORMAT OF TEXT F ...

Poster rated this answer

Collapse -

IMPORT & FORMAT OF TEXT FILES

by iaoi In reply to IMPORT & FORMAT OF TEXT F ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Software Forums