[AccessD] Excel to Access

Reuben,

Excel is fraught with danger when used directly, ESPECIALLY when it is hand
edited.  The reason is that the data can change data types down a column,
let's say it started as a number, but they then cut and pasted something
that Excel thinks is a string (but looks like a number).  When you link to
that sheet, you will end up with #error or something similar scattered
through your data.  If you must do this, then immediately export the data to
a CSV file.  The reason for doing that is that a CSV file has nothing in it
indicating what the data actually is, thus Access guesses when you set up
the import.  Further you can then specify each field intentionally if you
need to do so.  

So export to CSV
Import the csv data to a temp table
Work from that temp table. 


John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings
Sent: Wednesday, December 07, 2005 10:02 AM
To: AccessD
Subject: [AccessD] Excel to Access

Could someone point me to or provide a nice way to import Excel data in
Access on a daily basis.

A potential clients uses Excel daily to calculate some stuff about Mutual
funds.  They then want to send that data to Access at the end of every day
in order to have a history of the funds.

Thanks.

Reuben Cummings
GFC, LLC
812.523.1017




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