Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert Access Database to Excel?
I am a very new Access/Excel user. Is it possible to convert an Access
database to Excel? Thank you -- mae |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert Access Database to Excel?
Somewhat. At the core of Access, there are tables which are easily
transferrable to Excel. Limitations are that Access can store MANY more records/rows than Excel (pre-2007) can hold. To check, open up the Access tables, and see how many records there are. (note that its from here you can easily select all data, copy, and paste into XL) Typically, Access is used when dealing with large amount of records, or if you need lots of interactions/relations between the tables. But, with enough time and effort, (and again, provided not too many records) you could setup an XL workbook that does the same things. It just might not be as efficient. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mae" wrote: I am a very new Access/Excel user. Is it possible to convert an Access database to Excel? Thank you -- mae |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert Access Database to Excel?
mae wrote:
I am a very new Access/Excel user. Is it possible to convert an Access database to Excel? Thank you Something you might consider is to create a query to get the data you want and then export it to Excel. No conversion necessary. gls858 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert Access Database to Excel?
Hi,
Not only does Access support more rows than Excel, more importantly Access keeps its data in Tables, many tables. You need to decide what info you want to bring from Access and whether you want to maintain the data in Access and connect to it from Excel To connect to a query or table in Access from Excel you start by choose Data, Import External Data, New Database Query, then you step through the wizard. The advantage of this approach, although its quite a number of steps is that one connected you click one button (refresh) in Excel and Excel get the latest data from Access. If this sounds like what you want get back to us. -- If this helps, please click the Yes button Cheers, Shane Devenshire "mae" wrote: I am a very new Access/Excel user. Is it possible to convert an Access database to Excel? Thank you -- mae |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Convert Access Database to Excel?
"mae" wrote:
.. Is it possible to convert an Access database to Excel? Just to plaster-on some further thoughts to what the other responders have mentioned (disregard any thoughts overlap that's inherent) .. You could also try creating pivot tables directly from the Access source table/s (Access tables don't have the 65k row limitations per table - that's one of the main "strengths" compared to Excel 2003/lower) In Excel, in a new sheet, Click Data Import External data Import data Navigate to where the Access file is Select & Open Select Table In the Import Data dialog: Click on "Create a PivotTable Report", and you'd then be in the familiar Step 3 of Pivot wiz: Click Layout ... -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Access Database to Excel? | Excel Discussion (Misc queries) | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Do I need Excel or Access for my database needs? | Excel Discussion (Misc queries) | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
Convert MS Excel data to MS Access database | Excel Worksheet Functions |