[AccessD] Import errors from Excel

If you want the field to remain text go to the Excel sheet and make the
column text.  Or identify the field as a text field in the import
layout.  Otherwise Access will usually assume the field data is a
number.

Perry 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nathan
Hosburgh
Sent: Monday, December 07, 2009 1:40 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Import errors from Excel

Hi everyone - I'm rather new to the list and don't have incredible
experience with Access.

I've exported data to Excel from a website.  All the data looks ok when
it's in Excel, but when I import it as a new table into Access there are
errors.  There is a date field that has various date formats: 1995,
SUMMER 2002, SEPT-OCT 2005, Dec-08, etc.  I'm not concerned about
normalizing the data into consistent date formats... I can leave it as
text.  I have done this before with other tables and the data came
through fine in Access.  But, this time, some of the dates are coming
through in Access as 5-digit numbers.

It's really bizarre.  This happened to me originally a couple months
ago, then I did something to make it import correctly.  Now, of course,
I cannot remember what it was that I did.  I have a feeling it has
something to do with how I save the Excel file, but I'm not sure.

Thanks,

Nate

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com