RTF data from Excel 2007 to Access 2007

L

Lars

Hello

I cannot transfer RTF data from Excel 2007 to Access 2007. When transfering
RTF data to Access the formatting is omitted. I have tried to import to
existing table with RTF definition for the memo field, import to new table,
link to Excel and paste.

Excel data is however simple to paste from Word 2007 to Excel 2007 with
excellent visual result - it had been nice if this functionality had existed
also between Excel And Access.

It is however possible to manually paste formatted data (copied from one
whole cell in Excel) into an open field in Access. So it works - but I don´t
have the time to do this manually for each record in Access.

Is there a solution to this?
 
S

Stephen Raftery

I think the whole point of a database is that you keep the data in fields and
tables, and the formatting is kept completely separate, so what you are doing
is not really appropriate for a databse application

Stephen
 

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

Paste to excel from word - auto format problem 1
Lost .RTF 0
Integrating information from Word to Excel (not mail merge) 1
Cannot access to Office Insider 0
Word 2007: Was up-to-date, then a crash: I reinstalled from 2007 CD, but updates? 2
How to Create an S-Curve from Custom Field? 0
Linking data in MS Word into Excel 5
Import Excel 2010 table into Access 2010 - not listed as range 0

Top