Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access and Excel in VISTA
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access and Excel in VISTA
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access and Excel in VISTA
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel macros and vista | Excel Discussion (Misc queries) | |||
Excel 2007 and Vista | Excel Discussion (Misc queries) | |||
Excel 2000 and Vista | Excel Discussion (Misc queries) | |||
How to run Excel 2002 in Vista? | Excel Discussion (Misc queries) |