Force Access import wizard to text only format

[Guest]

The import or link wizard has a data type selection check box that is dimmed.
This should be activated during a data link with excel. This is to force
Access to accept the data type of a field as text, if some of the data
contained in the column is numeric. The wizard dos not take the field as text
even if the first few rows of data are text.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...e648e&dg=microsoft.public.access.externaldata

 

[Douglas J. Steele]

What version of Access? And do you have all of the Service Packs installed?

I believe this was fixed.

 

[Ken Snell \(MVP\)]

Not yet for EXCEL linking/importing....

 

[Douglas J. Steele]

I sit corrected. Thanks, Ken.

 

[Guest]

The version is 2003 MS Excel and Access.

Wish Microsoft had done something about this, it sure will help me a great
deal with what I am trying to do.

 

[Ken Snell \(MVP\)]

< g > It did get fixed for importing text files, that is most likely what
you were thinking....

 

[Ken Snell \(MVP\)]

I know that MS is fully aware of this limitation and has listened to many of
us who've requested changes... so, stay tuned, ya just never know what might
happen in the future.