Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    119

    Oh So Lost!! Unable to Import or get past set up.

    I am completely lost. spent last year learning access and my db is finally ready to be shared.

    MS Access 16


    SQL Server 19 (express)

    I knew it would take some figuring out how to get my db over to SQ Server but I did not think the learning curve would be so steep!!

    using the SQL Server Import export tool I cant even get past the first screen

    I have chosen "Data Source" as .net Framework Data Provider for SQL Server
    but when I click next I get
    "The ConnectionString Property has not been Initialized. (System Data)

    I have been though Hours and Hours of the MS help Documentation online and still cant seem to figure out what it is that it wants

    Any help is appreciated. Thanks


    Click image for larger version. 

Name:	Capture.PNG 
Views:	20 
Size:	113.4 KB 
ID:	44419

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,009
    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 Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    723
    Hi,
    if you want to import data from access to SQL server the data source is Microsoft Acces. So you don't have to give a connectionstring, but a file path.
    But befor importing your tables and recreate your queries as views I would advise to take a moment to look how SQL server works. Make sure you know the difference between the SQL data types and the Access data types; look into the SQL recovery models (having the SQL recovery model set to full without the proper log backup strategy will flood your hard disk) and learn about SQL security settings. This will take you maybe a few hours but spare days of frustration afterwards.

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

Similar Threads

  1. Replies: 7
    Last Post: 10-02-2015, 12:19 PM
  2. Replies: 14
    Last Post: 06-29-2015, 06:29 PM
  3. Replies: 3
    Last Post: 03-28-2013, 12:58 PM
  4. unable to import locked forms
    By jhargram in forum Forms
    Replies: 0
    Last Post: 02-29-2012, 03:22 AM
  5. Unable to import or link tables through odbc in Access SP2
    By Dave Jenkins in forum Import/Export Data
    Replies: 3
    Last Post: 11-09-2005, 11:51 AM

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 - Senior Forums