[AccessD] Excel to Access

John,

 I've had problems the other way to.  Had a text field in Access with a
store number in it.  One record had

'01010'

another

 '1010'

 Two different stores (customer's data; so don't ask<g>) Upon export, Excel
would ignore the text data type and treat the column as a number.  As a
result, the first record would end up with the leading 0 removed. Thus I'd
end up with two records with 1010

  You really need to watch what you do with Excel when you import/export.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby
Sent: Wednesday, December 07, 2005 10:16 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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