Linking Excel File

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

When I link an Excel file, one of the fields that is
formatted as text in Excel, comes across as a number field
in Access. Since you cannot change the property of a
linked table field, I cannot use the data coming from this
link.

How do I get this field to come over as text?????


Thanks...
 
Can you go into EXCEL and insert a ' character in front of each of the
values in the column? That will tell ACCESS to treat the value as a string?

Or, put in the first row the "nonnumeric" value so that ACCESS sees it and
knows that not all values are numbers.

If nothing else works, you can use Automation (via VBA code) to open the
EXCEL file and read the spreadsheet cell by cell and write the values into a
recordset that is based on a target table, thereby importing the data into
your database so that you can use the data.

Linking and importing EXCEL data can be frustrating because ACCESS tries to
be "helpful".
 
Back
Top