I am trying to import a Word table into Access. First I import the table into Excel and then into Access. The problem is that the Word table has several carriage returns within each cell, except for the "key" cell, which just has a part number.As you know, Excel will will create a new row everytjime it sees a carriage return imported. This completely screws up the import. There might be two ways around this:
1. Import all Word cells other than the "key" cell as memo fields. This prevents me from searching the field. BUT, I cannot figure out how to get Access to fromat the cell as it appears in the Word table.
2. Create some sort of macro that can convert the carriage returns into something else when I import the Word table into Excel.
Anyway, the goal is to be able to cut and paste a Word table into Excel and then into Access without having to do a lot of manual doctoring of the files. Also, I need to be able to export the Access table back into a Word table with the original Word formatting. Anybody have some words of wisdom for this?
Thank you for your help!
1. Import all Word cells other than the "key" cell as memo fields. This prevents me from searching the field. BUT, I cannot figure out how to get Access to fromat the cell as it appears in the Word table.
2. Create some sort of macro that can convert the carriage returns into something else when I import the Word table into Excel.
Anyway, the goal is to be able to cut and paste a Word table into Excel and then into Access without having to do a lot of manual doctoring of the files. Also, I need to be able to export the Access table back into a Word table with the original Word formatting. Anybody have some words of wisdom for this?
Thank you for your help!
