Import filtered Data from Access to Excel

[ootkhopdi]

HI.

I have a huge database containing table with 300000 records,,

i want to import filtered data from this access table into excel
as filter by Month or Year

how can i do it..

 

[Ranman256]

In your query, set the criteria,
Then use
Docmd.transferspreadsheet....

 

[Minty]

I suspect the OP wants to export to Excel having re-read his post.
Create a query that includes the filtered dates you want.
Then use DoCmd.TransferSpreadSheet to export the result of the query to the spreadsheet.

 

[ootkhopdi]

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

 

[sneuberg]

Try these step and see if that gets you in the right direction:

1. Open Excel with a blank worksheet
2. Click on the ribbon's DATA tab
3. In the Get External Data section click on From Access
4. Browse to the database you want to import from and click Open
5. Select the query or table in the database (Create the query in the Access database to meet your filtering requirements)
6. If you just want a table view then click ok on the Import Data dialog

 

[Galaxiom]

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.

 

[Ranman256]

You can't do it that way.
You don't need it open to import to excel.

 

[Galaxiom]

I have a huge database containing table with 300000 records,,

300000 records is not huge. In fact it is quite modest even for Access.

 

[ootkhopdi]

Thanks to all for suggestion and help

i do it with microsoft query option in data RIBBON...


select access database and some more steps..

i get my data...


thanks again to all