[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]On Behalf Of
> DWUTKA at marlow.com
> Sent: Wednesday, December 07, 2005 1:33 PM
> To: 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]
> 	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
> 	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
>