Data Type

[Kali]

Hello

I have an excel spreadsheet with some data. One of the column is formated
as Number. I need to format it to text, which I did and its seems to be
converting to text, but then when I import that file into access, it's
showing as Number. How and where can I can change the format to read Text as
data type in Access.

thanks in advance.

 

[Jerry Whittle]

You have a few choices.

1. Link to the spreadsheet and use something like the CStr function in a
query to force it into text/string.

2. Create the table first with the field as a text data type and then import
the spreadsheet into that table.

3. Create a bogus first row/record in the spreadsheet and put in text, like
XX, in that cell. When working with Excel, Access looks at the first few
rows. If it sees numerical characters in them, it assumes that column is all
numbers.