Results 1 to 4 of 4
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    527

    Trouble exporting to SQL Server

    I've done this before several times, but now I'm getting different results. Exports before used to go direct to the dbo schema. Now they are going to my personal schema MyOrganization\MyID.tblName.



    I have also tried using the Import Data feature in SQL Server. I got close once. now I'm at a dead end. I'm using Access 2016 and SSMS 2019
    Thanks, Paul

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,260
    I use a DSN that points to the SQL server.
    it reads/writes just fine. Even when I swap out the server from production to testing.

  3. #3
    Paul H's Avatar
    Paul H is offline Expert
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    527
    I do that all the time. What I am trying to do is export local Access tables to a SQL Server,
    Thanks, Paul

  4. #4
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    647
    Looks like the default schema for your user group has been changed. Check in SSMS - security -users the default schema for the database.

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

Similar Threads

  1. Upgrade from SQL Server 2008 to SQL Server 2014
    By RayMilhon in forum SQL Server
    Replies: 4
    Last Post: 07-12-2017, 04:54 PM
  2. Trouble exporting to file and preserving word wrap
    By Gary Childress in forum Import/Export Data
    Replies: 13
    Last Post: 09-30-2015, 03:49 PM
  3. Replies: 11
    Last Post: 02-26-2015, 11:00 AM
  4. Replies: 1
    Last Post: 08-17-2012, 04:50 PM
  5. Exporting to HTML Trouble
    By starhawk85 in forum Import/Export Data
    Replies: 2
    Last Post: 05-03-2012, 06:06 PM

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