With unlimited size in Excel in VISTA, can I copy an Access file to Excel and
do some manipulation of the data? Don't klnow Access and do understand
Excel? Thanks for any comments.
--
James D. Sheehan

James,

You can bring Access tables and queries into Excel, as long as they don't exceed the row
count for the Excel version you're using. Excel is great for manipulation and analysis of
data, but If you're thinking of moving the entire application to Excel, consider that Excel
isn't a data base program, and you'll lose the benefit of table relationships, data forms
and reports, queries, and all kinds of stuff. There's a little more in the topic "Database"
at http://www.smokeylake.com/excel/excel_truths.htm.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"James D. Sheehan" <jim@(E-Mail Removed)> wrote in message
newsB2E9A25-9659-490D-B553-(E-Mail Removed)...
> With unlimited size in Excel in VISTA, can I copy an Access file to Excel and
> do some manipulation of the data? Don't klnow Access and do understand
> Excel? Thanks for any comments.
> --
> James D. Sheehan

Thank you. I need a training session in ACCESS
--
James D. Sheehan


"Earl Kiosterud" wrote:

> James,
>
> You can bring Access tables and queries into Excel, as long as they don't exceed the row
> count for the Excel version you're using. Excel is great for manipulation and analysis of
> data, but If you're thinking of moving the entire application to Excel, consider that Excel
> isn't a data base program, and you'll lose the benefit of table relationships, data forms
> and reports, queries, and all kinds of stuff. There's a little more in the topic "Database"
> at http://www.smokeylake.com/excel/excel_truths.htm.
> --
> Regards from Virginia Beach,
>
> Earl Kiosterud
> www.smokeylake.com
>
> Note: Top-posting has been the norm here.
> Some folks prefer bottom-posting.
> But if you bottom-post to a reply that's
> already top-posted, the thread gets messy.
> When in Rome...
> -----------------------------------------------------------------------
> "James D. Sheehan" <jim@(E-Mail Removed)> wrote in message
> newsB2E9A25-9659-490D-B553-(E-Mail Removed)...
> > With unlimited size in Excel in VISTA, can I copy an Access file to Excel and
> > do some manipulation of the data? Don't klnow Access and do understand
> > Excel? Thanks for any comments.
> > --
> > James D. Sheehan
>
>
>