Importing memo datatype problem

[osx99]

Below is an append query which I use to import data from table [autonumbered import] into table [structure data sheet].

The field [Work Description] has a memo datatype in both tables but only a max of 255 characters ever imports across to the [structure data sheet] table.

Can anyone shed any light on why this is happening?

Thanks,
Osx



INSERT INTO [structure data sheet] ( [Structure Ref], PropUid, PropOpt, [Unique Structure Id], [GRIP Stage], [Structure Type], [Package Type], [Main Material], [Project Number], ELR, [elr low mileage], [elr high mileage], [Structure Name], [Structure Number], [Work Description])

SELECT DISTINCT ([Structure Data Sheet_Structure Ref]+1)-[min import number]+[max autonumber] AS Expr1, [autonumbered import].PropUid, [autonumbered import].PropOpt, [autonumbered import].[Unique Structure Id], [autonumbered import].[GRIP Stage], [autonumbered import].[Structure Type], [autonumbered import].[Package Type], [autonumbered import].[Main Material], [autonumbered import].[Project Number], [autonumbered import].ELR, [autonumbered import].[elr low mileage], [autonumbered import].[elr high mileage], [autonumbered import].[Structure Name], [autonumbered import].[Structure Number], [autonumbered import].[Work Description]

FROM [autonumbered import];

 

[tmcneil]

Hi osx99,

I'm having the same problem, but it occurs during my import process which I wrote in vba code and use transfer text to bring it into a place holder table. From this point, I use and update query then an append query to get the data into the correct tables. I did some thinking today, and if it truncates at 255 characters, it seems that access is treating it as a text field with a maximum field size of 255. I stil don't have a solution though.

 

[willir]

A veteran of Tek-Tips wrote an FAQ on memo fields...

http://www.tek-tips.com/faqs.cfm?spid=700&sfid=4188

Basically, a memo field not really a "field" but an object. In fact in older versions of Access you could not retrieve even 255 characters. Using the first 255 characters in a memo field as a text field is a bonus.

Instead of retrieving the memo field, can you use the link to the record instead?

Richard