By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 IT Pros & Developers. It's quick & easy.

Convert SQL2005 to MS Access

P: n/a
Hi all,

I am currently working on a project whereby I would need to create a
function that will convert an existing SQL 2005 Express database into
an Access 2003 database. I was initially thinking about SSIS but due
to licensing issues I have dropped that method. Has anyone does this
before? Does anyone know of a third party component that does this?

I did read that Attached tables would be the way to go but I am just
wondering is there any alternative as synchronization would be an
issue.

Thanks guys for having a think.

Joe

Jul 25 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 24 Jul 2007 18:10:41 -0700, Jo*********@gmail.com wrote:

What licensing issues? SQL Server 2005 comes with SSIS, doesn't it? No
special license required.

-Tom.
>Hi all,

I am currently working on a project whereby I would need to create a
function that will convert an existing SQL 2005 Express database into
an Access 2003 database. I was initially thinking about SSIS but due
to licensing issues I have dropped that method. Has anyone does this
before? Does anyone know of a third party component that does this?

I did read that Attached tables would be the way to go but I am just
wondering is there any alternative as synchronization would be an
issue.

Thanks guys for having a think.

Joe
Jul 25 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.