linked tables in MS Access

Noto · 26 Jan 2007 at 10:56

Hi, does anyone have experience with linked tables in MS Access.

I am linking to a MS Excel sheet. In that sheet is a field(column) where there is only 1 character. It is either a number or a letter. However MS Access when linking this field auto assumes that the whole field is of data type number. As a result all my text becomes #num! and my queries fail with data type mismatch.

I cannot change the datatype of the linked table either. And setting the entire field in Excel as "text" did not help either. Any ideas?

thanks in advance

Noto

TrUz · 26 Jan 2007 at 12:32

If the column in Excel only contains numbers then it will assume it is a field of type int. Just put some text in to set the link table up. From then on it should be ok.

TrUz

Noto · 26 Jan 2007 at 12:35

hi ya, the fields did have text in them. 0-9 and a-z. but numbers were on top. But i managed to get around the linked table and just use a macro and import the sheet using Transferspreadsheet. Thanks very much for the reply