Changing Format of when Linking Excel files

[Manuel]

Hi,

I have an Excel file I want to Link in Access but I need
to change the formatting (i.e. change a field from text
to number). The import wizard does not give me the
option to do this like when I import a text file. Anyone
got any suggestions how to accomplish this.

Thanks,

Manuel

 

[Joe Fallon]

Move your data around so that the very dfirst row of data has the "correct"
data types in each column.
e.g. If you expect text in a field then be sure the first row of data has a
character in it and is not just a number.
Same thing holds for numbers - be sure there is no character data in that
column.

Access and Excel communicate by examining the first 8 rows of data and then
Access makes a guess as to the data type. (The number of rows to use for the
guess is configurable in the registry.)