Results 1 to 3 of 3
  1. #1
    mutlyp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    1

    Transfering data from Access to SQL problem


    I have a 2010 Access database table that I need to convert over to SQL 2008 R2 database table. The table has over 10,0000 records in it.
    The problem is that every time I try to transfer the data over to SQL using the Access to SQL wizard in Access it gives me an error that say "Table was skipped or export failed" which is absolutely no help at all.

    Is there a way to get a more specific error to what is causing this to fail? I have also tried exporting the table to Excel and then trying to transfer the data into SQL but that doesn't give a much better error message than the Access to SQL wizard.

    Please help


    Thank you

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Have you already created the table in SQL? Can you set a link to the table? Then maybe just do INSERT SELECT to transfer data to the linked table?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    You can try the other way and import the Access table into SQL server using SSIS or the management studio import wizard.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Transfering data from form to table by button
    By pawelwolanczuk in forum Forms
    Replies: 13
    Last Post: 11-08-2014, 10:57 AM
  2. Replies: 3
    Last Post: 07-29-2014, 12:11 AM
  3. Replies: 3
    Last Post: 07-25-2012, 12:22 PM
  4. Problem transfering data from form to table
    By softspoken in forum Access
    Replies: 2
    Last Post: 05-12-2010, 11:17 AM
  5. Transfering data from one table to another
    By ron727 in forum Access
    Replies: 2
    Last Post: 04-26-2009, 11:33 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums