[AccessD] Excel to Access

Paul Hartland (ISHARP) paul.hartland at isharp.co.uk
Wed Dec 7 10:17:10 CST 2005


Wouldn't the best way to do this be to create a table, then get the user to
select the spreadsheet, then use the Excel objects and a recordset to import
the data line by line, you can then at least check for data conformity etc
as it's importing and give the user a report at the end.... 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 07 December 2005 16:07
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Excel to Access

Hi Reuben

Of course, this method requires consistent data.

/gustav

>>> Gustav at cactus.dk 07-12-2005 16:13:22 >>>
Hi Reuben

No need to import first.
Just link the Worksheet or Named Range. Then use a query to retrieve the
data.

/gustav

>>> reuben at gfconsultants.com 07-12-2005 16:02:27 >>>
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




More information about the AccessD mailing list