Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mamatha
Posting Yak Master
102 Posts |
 Posted - 2005-03-31 : 08:01:21
|
| HiI have table in SQL server,i created the table with same fields in MS-Access,now i want to insert all the data of SQL table into Access table.How can i do this?presently i get each coloums field of a table and insert into Access table,but this approach is going to slow while converting.Thanks in advance.MamathaMamatha |
|
|
ijprasad
Starting Member
29 Posts |
Posted - 2005-03-31 : 08:09:58
|
| Create an ODBC connection for SQL Server and use it from Access to transfer data in itInderjeet |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-31 : 08:59:31
|
| You Might want to look in books on line under Bulk copy.JimUsers <> Logic |
|
|
|
|
|
|
How to insert SQL table data into Access table?