Append query from Temp Table

G

Guest

Hi, I am importing data from Excel spreadsheet to a temp table which has one
field set as a memo field as there is a large amount of data in one cell of
my spreadsheet.
I then run an append query to insert new records into another table which
includes a memo field for the data in the memo field of the temp table,
however not all the data is imported to the new memo field instead it simply
cuts off at one point.

Can anyone help?
 
G

Graham Mandeno

Hi Allan

Is all the data in the field of your temp table?

Are you sure the final destination field is a Memo, not Text?

What is the length where the string is being cut off? Is it consistent? Is
it 255?

Can you post the SQL code of your append query?
 

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

"Record is too large" on append query attempt. Access 97 4
Data Type Issue in Linked Excel Table 7
Memo Field - Append Text fields into memo field??? 1
#DELETED shows up in memo field in local table 3
Strange Asian looking characters in output 3
Hard Returns in MEMO Field? (All as text) 3
Import memo fields from Excel spreadsheet 1
Memo Field in Table Truncated in query results and in report 1

Top