> 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";