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
Linking table to Excel file
- Thread starter Haz
- Start date
statsman
Active member
- Local time
- Today, 16:49
- Joined
- Aug 22, 2004
- Messages
- 2,082
It has been my experience in this area that if there are numbers in the Excel spreadsheet column, Access will ASSUME that it should be a number field.
You may have to change the field type in Access to text if thats what you want.
Remember, you can't do any math functions in Access if its set to text.
You may have to change the field type in Access to text if thats what you want.
Remember, you can't do any math functions in Access if its set to text.
Access will not allowed me to change filed type in access if it's linked table. I created make-table-query and then I can change the filed type which will solve my problem.
The field in excel file is mixed letters and numbers and the type is general. I changed to text and access still assumes they are numbers. Is there away for this problem without creating make-table-query?
The field in excel file is mixed letters and numbers and the type is general. I changed to text and access still assumes they are numbers. Is there away for this problem without creating make-table-query?
