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

Translating Text Document

P: n/a

Good morning group. When I translate a text document into access, the data
does not align exactly into the fields. It may be spread over three
different fields.

Two questions; How do I keep the text columns straight so the data is in
the exact field? And, if the data cannot be placed into a single field, how
can the fields be merged so that all the particular data falls into the
field where it must be?

Thanks Group!

Norm Parsley
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> When I translate a text document into access, the data
does not align exactly into the fields. It may be spread over three
different fields.

Two questions; How do I keep the text columns straight so the data is in
the exact field? And, if the data cannot be placed into a single field, how
can the fields be merged so that all the particular data falls into the
field where it must be?

The reason the data doesn't align into the fields from a text document
in to MS-Access is because you haven't given it any
specifications/instructions about where to go.
Either start off by inserting a table within your text document to
contain the necessary fields. After it is imported--using File, Get
External data, then the columns should line up correctly. You can also
cut & paste the data from one application to another--like WORD to
MS-ACCESS.

If it still doesn't work properly, you need to specify a delimiter for
your fields:
meaning a character that tells the computer where the breaks are.
Heres's an example using ; as a delimiter. Try not to use commas as a
delimiter they are used to often. The first row is the header names:
FirstName;LastName;Department;jobTitle;DateReceive d;Location;Address;City;State;Zip;Email
"Paul";"Wamm";"Department of War, EH-6";"Industrial
Hygienist";"20030707";"EH-6/270 Corporate Square Building";"1000
Independence Avenue,
SW";"Washington";"DC";"20585-0270";"Pa*******@dow.gov";
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.