Import filtered Data from Access to Excel (1 Viewer)
- Thread starter ootkhopdi
- Start date
thanks to both Ranman 256 and Minty
but ur solution is Export Access database to Excel
while i want
IMPORT Data From Access into Excel
as
First i open an excel worksheet
then import data from access table
but this time i want to filtered data only which match with my requerements
hope i clear my problem ..
hoping to solution
thanks in advance
but ur solution is Export Access database to Excel
while i want
IMPORT Data From Access into Excel
as
First i open an excel worksheet
then import data from access table
but this time i want to filtered data only which match with my requerements
hope i clear my problem ..
hoping to solution
thanks in advance
Try these step and see if that gets you in the right direction:
- Open Excel with a blank worksheet
- Click on the ribbon's DATA tab
- In the Get External Data section click on From Access
- Browse to the database you want to import from and click Open
- Select the query or table in the database (Create the query in the Access database to meet your filtering requirements)
- If you just want a table view then click ok on the Import Data dialog
Typically, if it were a fixed database you were connecting to you would use Get External Data on the data ribbon and set it to reload on opening. This can connect to a query or table or you can edit the Command type and Command Text in the Connection definition to execute any SQL.
If the database changes then you can change the Connection file and Connection String.
Another alternative is to use an ADO Connection and ADO Command to get a recordset from the database then CopyFromRecordset to write the data into a Range.
If the database changes then you can change the Connection file and Connection String.
Another alternative is to use an ADO Connection and ADO Command to get a recordset from the database then CopyFromRecordset to write the data into a Range.
300000 records is not huge. In fact it is quite modest even for Access.
