Linked tables

J

John Burkard

I'm trying to link an access 2000 table to an excel table. The first field
would be the key. It has mixed data which includes some records with
numbers only. I have formatted the column to be "text" and the numbers are
thus, left aligned. If I put a text record at the top, I get a # error for
all the records that have numbers only. With a number record at the top, I
get a #? error for the text entries. I've tried alternating the first few
records between numbers and text but I still get errors on one type of
record or the other. What can I do? I don't want to type in a few hundred
records when the data is already available.
 
V

Van T. Dinh

I assume you meant you have an Excel Spreadsheet and you want to use this as
a "Linked Table" in Access.

If you have a mixed Column in Excel, I think the best way is to create a
Calculated Column in Excel using the Spreadsheet TEXT() function to convert
the mixed Column to Text Column. When you link the spreadsheet, use the
Calculated (Text) Column which will be recognised by Access as Text and
ignore the mixed Column.

Check Excel Help on the spreadsheet function TEXT().

HTH
Van T. Dinh
MVP (Access)
 
Top