Access 2003 truncating data using ODBC import

=?Utf-8?B?Um9nZXJpblRleGFz?=

Guest

Posts: n/a

11th Jan 2005

I have Access reports that bring in data from Lotus notes via ODBC. In
Access 97, I get 250 characters per field imported through ODBC link tables.
With Access 2003, using the same ODBC driver and databases, Access truncates
the fields at 200 characters. I need the rest of these fields - any idea how
to fix?

« Importing a date field from txt file to Access | Importing files with .bcr extension »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access Truncating Linked ODBC field names	pa1971	Microsoft Access	1	15th Jan 2010 04:24 PM
ODBC Driver Too Few Parameters - Import External Data from Access	snandula@gmail.com	Microsoft Access External Data	0	20th Jun 2008 10:44 PM
How I import data without truncating zero in the beginning	Mohsin Habib	Microsoft Access	2	16th Jan 2008 04:16 PM
How I import data without truncating zaro in the beginning	Mohsin Habib	Microsoft Access	1	16th Jan 2008 09:16 AM
Memo field in Access 2003 is truncating the data	=?Utf-8?B?U3VzYW4gTWF5?=	Microsoft Access External Data	1	27th Apr 2007 04:51 PM