Hi,
Has anyone tried to import data conditionally fro SQL Database to access DB??
I am Importing data from SQL Server to my Access Database to generate report. But SQL server is having large number of data which will cross limit of 2 GB of Access Database. So, I want to Import data data conditionally from SQL Database, Means Whatever Input I will give to filter Data in Access only that much of data should have to get imported from SQL DB to Access DB. And After completion of that Task Access DB Should have to be Blank. Which means It will not Consume Space of Database.
Awaiting for Reply...