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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Convert Access to SQL with Attachments

Author  Topic 

Mandeo
Starting Member

2 Posts

Posted - 2008-08-05 : 10:26:53
We are trying to convert an access .accdb database to SQL Server 2005 and the access has different types of attachments, mainly .doc and .zip. I looked into converting from access to xml and then converting the xml to sql but I haven't found a good tutorial for that. I am wondering if there is an easier way to do this?

Thank you.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-05 : 23:27:26
Why don't just use Access' upsizing wizard?
Go to Top of Page
   

- Advertisement -