SQL Server 2005 Express import of Access

Hot Topic

SQLExpress - SQL Developer - Let Sleeping Dogs Lie...
SQL Server 2005 Sept CTP - Failed Installation - It Wants Disk 2????
SQL Server 2005 Timeout expired exception
Extending Management Studio
Install Error with Sept CTP
Urgent help please!!!!! Error trying to uninstall RS sql 2k5
Need help rotating a table
error changing subscription properties
Do Table Value Functions eliminate parallel execution plans?
DTS Legacy and SQL 2005

SQL Server

What is the best way to setup a staging table
Impact of "Rows per batch" on OLE DB Destination?
SQL Server Toolbox & Designer
How to show two dataset with equal & non equal of multiple selection.
Does a checkpoint file record a package's state
About Indexes & Where caluse
MICROSOFT JET OLEDB 4.0????
international db
default value for a parameter to select all
AS Processing Task

SQL Server 2005 Express import of Access

  

  I have installed SQL Server 2005 Express on a laptop for development purposes and would like to import some Access databases that I was using coupled to programs written in VB 6.

 If using SQL Server 2000 I could use the management studio to automate the import but I can not find any way to do this in Management Studio Express. Would have thought that this would be the typical migration route - Access to Server Express

   Is there some way to automate this procedure

Thanks

 

 

Answer this question

SQL Server 2005 Express import of Access

  • archdukefranz

    1, Make an Access Project
    2, Import the data with Access to the project (you can select another Access database to import)
    3, It will be uploaded to the database

    OR

    You can use a 3rd party database management tool which supports importing .mdb's.

    Robert

  • Don Jefe Leone

    Using the ODBC connection worked well. Thank You.

  • Kennysarmy

    I don't think that feature is available with Express.

    http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

     

  • Kapil Aggarwal

    How did you actually code this process


  • Brian B

    The only way I found to 'import' to Express from Access was actuall to 'Export' from Access to an odbc connection of the Express database.

  • Suma Sushilendra

    I went into Access, right-clicked the table(s) and chose Export. Then i selected the Sql Server Express database and an odbc connection (which I had created earlier).

  • Brad Radaker

    I have Access 2000 and have not been so lucky. I've read that you cannot upsize from Access 2000 to SQL Express.

    What version of Access did you export from

    I was finally able to import my Access 2000 tables into SQL Express by using some tool called "SQL Admin Tool" from Simego.com

    http://www.simego.com/Default.aspx

    It's $30 bucks but the full-version demo lasts for 30 days and I could import what I needed to in less than a minute.



  • SQL Server 2005 Express import of Access
Answer this question