data type limit

[vientito]

In excel each cell has a storage limit to a string up to 32K.

In access each record of data type string is limited to 255

If I link a table from Excel to Access, how would Access know what data type it is supposed to interpret? If it interprets as string then the limit will be drastically reduced and my record would end up appearing chopped off.



I suppose Access will not assume a memo type for a typical string in Excel, wouldn't it?

I know Excel seems also to place a limit to which the characters can appear on the worksheet though it is much smaller than what it can store up to.

[June7]

From what I remember, truncation of more than 255 characters can depend on method of import.

1. import wizard

2. DoCmd.TransferSpreadsheet

3. open and manipulate Excel object in VBA

[NTC]

set up a table in Access and specifically define the field type as Memo

then link to the excel sheet

then make an Append or Update query to write the data from excel to Access