Import data from Word tables and XCEL spreadsheet

M

marilyn

Is it possible to insert Word tables and EXCEL spread
sheet data into ACCESS memo fields?
 
J

John Nurick

Hi Marilyn,

In general the answer is no. A memo field can only contain plain text
with absolutely no formatting beyond line breaks. The standard textbox
control doesn;t even understand tab characters.

If you want to use the data in the Word and Excel tables you should
normally import it into properly normalised Access tables. Otherwise,
it's generally best to leave the Word and Excel documents in network
folders and just store their names, locations and other metadata in the
database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
List all tables, including document structure 0
Adding data to MS Access from csv file 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Linking data in MS Word into Excel 5
Creating a Chart on form from selected data in query. 0
Bugs in Office 2019 0
Mail Merge Directory Conditional Page Break 0

Top