[AccessD] FW: Excel to Access

Ooops, was using OWA, and hitting reply sends the reply to the sender, not
to the list....got a dozen of these to resend on OT.

Drew

-----Original Message-----
From:	Drew Wutka 
Sent:	Wednesday, December 07, 2005 1:55 PM
To:	'Reuben Cummings '
Subject:	RE: [AccessD] Excel to Access

I wrote an Excel To Access Comparer.  It's on planetsourcecode.com in the VB
section.  The code can be read with just notepad.
Drew
-----Original Message-----
From:	Reuben Cummings
To:	Access Developers discussion and problem solving
Sent:	12/7/05 12:55 PM
Subject:	Re: [AccessD] Excel to Access

Anyone care to share some code?
I need...
1.  How to get into the spreadsheet.
2.  How to put a specified range or column from a given page into a CSV

Once I have the CSV I think I can handle it.  However, if anyone has some
nice suggestions for reading from the CSV I'm listening.
I apologize for asking so much.  This company called me about a year ago and
then let the project die before I even started researching this stuff.  Now
they call me out of the blue and want it done NOW no matter the cost.
Reuben Cummings
GFC, LLC
812.523.1017


	> -----Original Message-----
	> From:	accessd-bounces at databaseadvisors.com
<mailto:accessd-bounces at databaseadvisors.com> 
	> [mailto:accessd-bounces at databaseadvisors.com]
<mailto:[mailto:accessd-bounces at databaseadvisors.com]> On Behalf Of
	> DWUTKA at marlow.com <mailto:DWUTKA at marlow.com> 
	> Sent:	Wednesday, December 07, 2005 1:33 PM
	> To:	accessd at databaseadvisors.com
<mailto:accessd at databaseadvisors.com> 
	> Subject:	Re: [AccessD] Excel to Access
	>
	>
	> Personally, I prefer to use ADO to communicate with Excel.  It's
fast,
and
	> easy to use.
	>
	> Drew
	>
	> 	-----Original Message-----
	> 	From:	Reuben Cummings [SMTP:reuben at gfconsultants.com]
<mailto:[SMTP:reuben at gfconsultants.com]> 
	> 	Sent:	Wednesday, December 07, 2005 9: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
<mailto:AccessD at databaseadvisors.com> 
	> 	http://databaseadvisors.com/mailman/listinfo/accessd
<http://databaseadvisors.com/mailman/listinfo/accessd> 
	> 	Website: http://www.databaseadvisors.com
<http://www.databaseadvisors.com> 
	> --
	> AccessD mailing list
	> AccessD at databaseadvisors.com <mailto:AccessD at databaseadvisors.com>

	> http://databaseadvisors.com/mailman/listinfo/accessd
<http://databaseadvisors.com/mailman/listinfo/accessd> 
	> Website: http://www.databaseadvisors.com
<http://www.databaseadvisors.com> 
	>




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