Prev: Delete Records from Table using Query Results
Next: Parse Suffix from Last Name Field
From: Gary on 7 May 2010 14:11
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
From: KARL DEWEY on 7 May 2010 14:27
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
 | 
Pages: 1
Prev: Delete Records from Table using Query Results
Next: Parse Suffix from Last Name Field