conversion from one database to another

[kriti]

I have a table in SQL i want to convert it to ACCESS

[TheCPUWizard]

I have a table in SQL i want to convert it to ACCESS

1) Open Access
2) Attach to SQL Table
3) Run an Insert Query.

OR

1) Open Access
2) Select Import

OR

1) Open Management Studio
2) Export Table to Flat File
3) Open Access
4) Import Flat File