Linking with Excel

T

tartan tim

I understand that for legal reasons an Excel to Access linked table cannot be
changed.

Is it possible to set the data type prior to linking. I have tried to link a
field as "Memo" but when I link it reverts to "Text" as I need more than 255
characters.

Any thoughts?
 
Top