[AccessD] Converting from Excel to Access

Just some quick thoughts. If you are importing from an Excel table with sums
be careful Excel doesn't suck in the totals as a separate garbage record. 

Generally I  import the unnormalized tables without keys into Access first
before creating all the required normalized tables with indexes and keys
from inside Access. Importing the data first allows me to quickly determine
if there are any issues with the data- nulls, data conversion problems, etc.


If you are importing ranges make sure the ranges include all the data. You
would be surprised how often this turns out to not be the case.

Jim Hale

-----Original Message-----
From: Thomas F. Ewald [mailto:tewald at wowway.com]
Sent: Sunday, March 19, 2006 12:51 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Converting from Excel to Access


No, I mean taking a complex workbook, which should have been in Access in
the first place, and recreating it as an Access database, complete with
relationships, forms, reports, etc. Of course this depends on how it's been
used and will be used; I was looking for a generic list of things to watch
out for. Data types would be on the list, I would expect.

Thanks, 

Tom Ewald

Date: Sat, 18 Mar 2006 14:33:44 -0500
From: "Susan Harkins" <harkinsss at bellsouth.net>
Subject: Re: [AccessD] Converting from Excel to Access
To: "'Access Developers discussion and problem solving'"
	<accessd at databaseadvisors.com>
Message-ID: <000001c64ac2$df5fb4a0$92b3d6d1 at SUSANONE>
Content-Type: text/plain;	charset="us-ascii"

By convert, do you mean import? The biggest gotcha I've found when importing
Excel data into an Access database is data type problems. 

Susan H. 

Does anyone have a list of items to watch out for when converting a database
from Excel (multiple worksheets) to Access? I can do it all right, but a
checklist, some instructions, some hints, etc., could certainly be helpful.

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 3/17/2006
 

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

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.