Linking table to Excel file

[Haz]

I have a table in Access databse link to excel file in the network, the format of the fields of this file are set to general. When I create a link table wizard the fileds formats changes to numbers for some of them. It's wierd, I spent a lot of time figuring out what is the problem and creating new excel file with changing the fields format around and still not solving the problem. Any idea or help for this problem is apperciated. Thanks

 

[neileg]

Excel doesn't support the idea of a fixed datatype. It will accept any old rubbish in any cell with little or no protest. No matter what you do in Excel, you can't really change this behaviour.

When you link or import into Access, it guesses the datatype from the first few records. If those records have numbers in a column, it will set the datatype to number. If subsequent records have text in that column, it falls over!

Just because you can link an Excel sheet as a table doesn't mean it's a good idea, as I think you have found out.

 

[DannySeager]

What are you trying to do with the data? are you trying to use it as a datasource for form or are you trying to import it into an access table?