ACCESS2SQLSERVEREXPRESS

Hello,

First of all, please excuse my english... I'm french :-D

Can someone give me a way to convert an Access2 DB to a SQL Server 2005 Express ?

Is it possible ?

Thanks,

I managed to export datas from ACCESS2 DB in text format.

Can I insert from a text file datas in SQLExpress ? Even if I don't need all the fields ?

Thanks,

|||

Is this a silly question ?!?

I read that SSIS is not in SQL Server Express and I'm trying to find a way to import Access2 DB to SQL Server Express DB...

|||

There is tool from Microsoft to convert Access Database into SQL Server 2005 database. I have no link for it. You can search it from Microsoft's website.

|||

For importing text files into SQL Express, take a look at the BCP tool, more information is in the BOL.

You can also take a look at the SQL Server Migration Assistant for Microsoft Access. I'm not sure this tool is capable of working with Access 2.0 databases, since that version hasn't been supported for some time now.

Another possibility would be to try the built in Export functionality in Access to export data directly to SQL Server.

Mike

|||

Thank you very much ! I have never heard about this SQL Server Migration Assistant, even when I was searching in MS website. It is exactly what can help me and it works with Access2.

Thanks a lot again

Best regards

Nico