Collins, Darryl
Darryl.Collins at anz.com
Mon Dec 7 17:05:23 CST 2009
I ususally load the data from Excel line at a time via ADO. It is slower than some of the other transfer methods, but far more reliable as you can verify and enforce the type of each piece of data you are uploading before sending to the back end database. I will take accuracy and reliability over speed anyday. There is no point is being fastest but wrong IMHO. Besides, it is not that much slower than the fastest method to be pesky. Regards Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, 8 December 2009 8:59 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Import errors from Excel The simplest way to address that is to create an Import/Export spec for the Excel worksheet and make sure that column is specified as text. Otherwise, unless you are importing into an existing table, Access will use the imputed datatype of the first value in that column to decide how to handle it. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nathan Hosburgh Sent: Monday, December 07, 2009 10:40 AM 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com "This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."