M
mae
I am a very new Access/Excel user. Is it possible to convert an Access
database to Excel? Thank you
database to Excel? Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Luke M
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.
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.
G
gls858
mae said: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
S
Shane Devenshire
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.
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.
M
Max
mae said:.. 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
---