[AccessD] RE: Access 2002 - Another Annoyance

My "work around" for that little "quirk" is to make sure that the first row
of my Excel file has text, numbers, dates etc in the desired columns. Bit of
a bodge, but it works for me ;-)

Regards
Chris Foote - UK

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
dmcafee at pacbell.net
Sent: 27 May 2005 17:23
To: Access Developers discussion and problem solving;
ACCESS-L at PEACH.EASE.LSOFT.COM
Subject: [AccessD] RE: Access 2002 - Another Annoyance


I hate it when Access tries to be "too smart" for its own good. I'm sure the
MS programmers were trying to validate something (with good intentions). I
hate it when they do that, just like when trying to import an Excel file
with numbers in a column, but you really want to import that column as text.
Access wont let you :|

David