Importing Memo Fields from SQL to Access

P

Phil

From the GUI I am selecting Get External Data, Linked Tables to pull data
from an SQL database via ODBC in Access. Access defines the memo fields as
MEMO type. But the fields are truncated. Is there any way to correct this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Extracting Long String Fied from SQL Server to Access 2003 5
import csv truncation 1
Access: Memo Fields Being Cutoff When Exporting Reports into Rich 4
output memo to RTF 2
Linked table column type changes from text to memo 1
transfer to excel 1

Top