Question Can i use cursor to copy data to sql?

[Alrick]

I've to copy data from access to sql server 2008? Can i use Cursor? Pls explain me.eaceful:

 

[Alrick]

Copy data from access to sql with Openrowset

How to copy data from MS Access to Sql Server 2008 using openrowset. Access Databases have been joined system file.

 

[Estuardo]

G'd morning!
What you need to do is for one time or in a regular basis? if is just once or very rare you may want to see this Download: SSMA for Access 5.2 - Microsoft Download Center - Download Details
G'd luck