If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Another Table Conversion question
Hi,
I have a word document that has a huge table on it that I would like to get into an Access Database. Using Excel as a go between seems like it should work. I have tried just copy and paste into Excel, but for some reason, it doesn't go properly. The table consists of 3 columns. Command Syntax Description The Command and Syntax columns are fairly short length data, maybe 30 or 40 characters or less. The description column has some with no data, up to some with what I'd estimate maybe 1.5k - 2k characters. I've tried to just copy/paste of a single row for testing as well. What I see in Excel is the first 2 columns inport properly, it seems, but the third column seems to get broken into several vertical cells, like there's a limit to the field length. Unfortunatly, this document was converted from WordPerfect. Some of the longer Decsription fields also have non-printable characters. Short of either retyping or cut & pasting 100's of times, any suggestions ? Thanks, DanS |
#2
|
|||
|
|||
Another Table Conversion question
It may be better to ask in an Access Newsgroup.
There is no doubt however that it can be done using code that iterates through the rows of the table. The last in the following series of articles will give you an idea about how to get data from Word into Access Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "DanS" wrote in message . 96.78... Hi, I have a word document that has a huge table on it that I would like to get into an Access Database. Using Excel as a go between seems like it should work. I have tried just copy and paste into Excel, but for some reason, it doesn't go properly. The table consists of 3 columns. Command Syntax Description The Command and Syntax columns are fairly short length data, maybe 30 or 40 characters or less. The description column has some with no data, up to some with what I'd estimate maybe 1.5k - 2k characters. I've tried to just copy/paste of a single row for testing as well. What I see in Excel is the first 2 columns inport properly, it seems, but the third column seems to get broken into several vertical cells, like there's a limit to the field length. Unfortunatly, this document was converted from WordPerfect. Some of the longer Decsription fields also have non-printable characters. Short of either retyping or cut & pasting 100's of times, any suggestions ? Thanks, DanS |
#3
|
|||
|
|||
Another Table Conversion question
"Doug Robbins - Word MVP" wrote in
: It may be better to ask in an Access Newsgroup. There is no doubt however that it can be done using code that iterates through the rows of the table. The last in the following series of articles will give you an idea about how to get data from Word into Access SNIP Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 Thanks, I'll take a look. |
Thread Tools | |
Display Modes | |
|
|