How to convert sql server table data into MS Access(.mdb) file I have SQL Database table with 6664055 rows, I want to convert this SQL Server table data to MS Access format(.MDB), How Can I do this?
Please have a look at the SQL Server Import and Export Wizard

SQL Server Import and Export Wizard