Linking xls sheet to Access DB- can I prevent truncating of data?

C

CAPcoordinator

Hello all-

I am wondering if anyone can tell me whether it's possible to prevent my
data from being truncated, when I link an Excel worksheet to my Access 2003
DB? If so, how? My data is not truncated when I Import the Excel sheet but I
would prefer to link rather than import if possible...

thank you much
-Chris
 

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

linking xls worksheet to Access without truncating text in xls cel 1
Linking to a mainframe database 10
linking to SQL Server db table 6
Linking Query to Excel make DB Read Only 0
Linking To .XLS: Some Dates = "#Num!" ?? 14
How I import data without truncating zaro in the beginning 1
Linking To .XLS: Controlling Column's DataType? 0
Outlook 2007 to Access 2007 via External Data Error 0

Top