Linking Excel Into Access Issue

I am using Acc 2003, but Acc 2007 should work the same (I think).

I have linked an excel spreadsheet into my Access database. Almost all of
the fields are available and can be read.

There are a few fields that I can see in Access, but its in Excel sheet.
These
fields were using a VLookUp function in excel to get the value from another
excel worksheet.

Also the linked excel sheet has fields that I believe should be text (in
Access), but its was set to be a number. I am unable to change this.

Is there a way to resolve this issue for me ???

I also assume that if I was to read each cell in the excel sheet and convert
it into text files using VBA code, that should resolve the issue.

Does someone have any suggestions for me ???


Thank You,

G

One way is to remove the link, add a phony row of data in Excel just under
column names, re-link, and remove phony row of data.
Access looks at first rows of data to determine datatype. Using text in the
phony row will make Access bring that column.field in as text.

--
Build a little, test a little.


"Gary" wrote:

I am using Acc 2003, but Acc 2007 should work the same (I think).

I have linked an excel spreadsheet into my Access database. Almost all of
the fields are available and can be read.

There are a few fields that I can see in Access, but its in Excel sheet.
These
fields were using a VLookUp function in excel to get the value from another
excel worksheet.

Also the linked excel sheet has fields that I believe should be text (in
Access), but its was set to be a number. I am unable to change this.

Is there a way to resolve this issue for me ???

I also assume that if I was to read each cell in the excel sheet and convert
it into text files using VBA code, that should resolve the issue.

Does someone have any suggestions for me ???


Thank You,

G