Changing Format of when Linking Excel files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Manuel - 01 Sep 2004 04:49 GMT

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

Reply to this Message

Joe Fallon - 02 Sep 2004 02:15 GMT

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

Signature

Joe Fallon
Access MVP

> Hi,
>
[quoted text clipped - 7 lines]
>
> Manuel

Reply to this Message