On the basis that the stupid question is the one not asked, I'll venture a question: I frequently wish to put lists and catalogues into access. However, I cannot seem to find clear instructions on the characters I need to insert into the documents to enable access to separate the records and fields. Any pointers?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Word docs convert to Excel/Access 1
- Thread starter nickle
- Start date
-
1
- #2
Hello Nickle,
You will want to use the Import Wizard that Access provides. With this utility you can use any character at all to separate the data in your prospective fields. These characters include, of course, Tab, Space, Comma, Semi-Colon, Colon, etcetc.
You access this wizard by clicking "New" when in the "Table" window of Access and then selecting "Import" or "Import Table"...whatever it says, something like that. You will then want to select "Delimited" and proceed to the next window of the Import Wizard. There you will see that you can select the "delimiter" of your choice, or you can define your own "delimiter".
The only thing to keep in mind here is that your delimiter must be used exclusively as a delimiter in your original document. I mean, if you choose the "space" character as your delimiter (or any other, the comma, for example) and the "space" character appears as part of your data (examples: John Smith, 100 E. Main St., Anywhere, USA), then the Import Wizard will want to separate the data in your fields based on that delimiter. So you would have John in one field, Smith in another, where you may want them both in together. Same applies for Field1: 100, Field2: E., Field 3: Main, Field 4: St., Field5: Anywhere, etc)
Oh yeah, before you can use the Import Wizard, you have to first save your Word document as a text file.
You can do the exact same thing in Excel. The Import Wizard is found in the Data>Get External Data>Import Text File menu.
Hope I correctly understood your objective. If so, hope also that this helps.
Mike Kemp
kempmike65@aol.com
You will want to use the Import Wizard that Access provides. With this utility you can use any character at all to separate the data in your prospective fields. These characters include, of course, Tab, Space, Comma, Semi-Colon, Colon, etcetc.
You access this wizard by clicking "New" when in the "Table" window of Access and then selecting "Import" or "Import Table"...whatever it says, something like that. You will then want to select "Delimited" and proceed to the next window of the Import Wizard. There you will see that you can select the "delimiter" of your choice, or you can define your own "delimiter".
The only thing to keep in mind here is that your delimiter must be used exclusively as a delimiter in your original document. I mean, if you choose the "space" character as your delimiter (or any other, the comma, for example) and the "space" character appears as part of your data (examples: John Smith, 100 E. Main St., Anywhere, USA), then the Import Wizard will want to separate the data in your fields based on that delimiter. So you would have John in one field, Smith in another, where you may want them both in together. Same applies for Field1: 100, Field2: E., Field 3: Main, Field 4: St., Field5: Anywhere, etc)
Oh yeah, before you can use the Import Wizard, you have to first save your Word document as a text file.
You can do the exact same thing in Excel. The Import Wizard is found in the Data>Get External Data>Import Text File menu.
Hope I correctly understood your objective. If so, hope also that this helps.
Mike Kemp
kempmike65@aol.com
Oh yeah, this can all be automated progmatically also with the "Docmd.Transfer Text...." macro command. This way you can import all of your text with the click of a button. This would be helpful if you do this data transfer on a regular basis.
Mike Kemp
kempmike65@aol.com
Mike Kemp
kempmike65@aol.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question