Changing Format of when Linking Excel files

  • Thread starter Thread starter Manuel
  • Start date Start date
M

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
 
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.)
 
Back
Top