Link Table Error/Design Change Blocked

N

nw003

I have a field in my excel document that contains both numbers and numbers
and letters combined. When I link the database into Excel it errors out the
fields and the field appears blank. I attempt to change to a text field on
the table design but it will not allow me to modify. The field properties on
excel are text.
 
J

Jeff Boyce

One approach in this situation is to treat the Excel data source as "raw
data". If you create a table definition with the data types you want, then
import the data from Excel into your new table, you'll be starting with the
data type you want. The downside is that you are importing, not linking.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Top