[AccessD] Excel to Access

How could I go about exporting specific portions of an excel spreadsheet to
a CSV from Access?

I would prefer to have them open the Access app and click a button to bring
the data in.  The function in Access would send the data from the specified
ranges (which would be hard coded for now) to a CSV, import that to a table,
and then format and place the data accordingly.

Reuben Cummings
GFC, LLC
812.523.1017


> -----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
>