Problem importing ODBC data tables

[Anderson]

Hi
I wonder if I could ask for a bit of help - I'm trying to import an ODBC data source into a new table, and one of the fields contains quite a lot of text. Access only seems to import a certain number of characters, not the whole text, which I need in order to run the queries I'm trying to.
Anyone know if there's a setting anywhere to increase the amount of text that Access can import into a field?
I would be happy to give any more details you think would be helpful
Thanks in advance

 

[Trevor G]

You would need to see if you can set the ODBC connection to use a Access Memo field, this will allow you to use upto 64000 characters depending on which version of access you are using.

you can also look up googling ODBC to dbMemo field

here is one link

http://support.microsoft.com/kb/214854

there are many out there.