Data Type to Link Excel Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel workbook that I want to link to my database, when I do it
reads the PO column as a number. I have that column as text in Excel, why
does Access think it's a number. In the column I have either the PO Number
or the word None list for each part.

How can I tell Access what I want the datatype of each field to be?
 
There are two possible approaches.

1. Save the spreadsheet as a .csv file, then the first time you link, you
can click on "advanced" and create an importspec that will set up the data
the way you want it. After that, just identify the import spec when you link.

2. Instead of linking, create a table in the database that has the fields
defined like you need them where you want the data to be. Then, each time
you need it, delete the data out of the access table and do a copy to an
existing table.
 
Back
Top