Results 1 to 8 of 8
  1. #1
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338

    Import/Export dat into SQL

    Hello

    I’m looking to automate some of my import and export data. I’m running reports on a daily basis from a system which exports to excel spreadsheet.


    I would like to import this data into a temperature table in access than split text with delimiter on one column and import the data into sql server.

    Thank you

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    What part do you need help with? You'll probably be using TransferSpreadsheet, Split() and the AddNew method of a recordset.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    I would need help with all of it. I have use access before but I'm still learning.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Have you looked at the tools mentioned? Have you started anything? Or by "help" do you mean you want somebody to do it for you?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    Just looked into the tools you mentioned. I'll start working on those.
    Thank you for your help

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, post back if you get stuck.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    So far this is what I was able to put together based on a recent thread. First-The code deletes any current rows in the Temp table Second- It imports new data from excel to Temp table
    Need help with the third step. After the new data is imported I would like to split one column into 4 column

    This is how the column is now
    Reconciliation
    MK-EFT-PMT-Ray
    JB-BCBS-PMT-Ray

    Thank you

  8. #8
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    That would be the Split() function I mentioned earlier, in an update or append query.

    ?Split("MK-EFT-PMT-Ray","-")(0)
    MK
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. My saved import/export are gone
    By egyhamada in forum Import/Export Data
    Replies: 4
    Last Post: 02-06-2016, 08:47 AM
  2. Export & import some records
    By ScottXe in forum Import/Export Data
    Replies: 1
    Last Post: 04-20-2015, 11:39 AM
  3. Automating import and export
    By trotta in forum Access
    Replies: 4
    Last Post: 02-19-2013, 06:51 AM
  4. export/import by email
    By sue tang in forum Import/Export Data
    Replies: 5
    Last Post: 03-14-2012, 04:41 PM
  5. Export / Import situation
    By svcghost in forum Import/Export Data
    Replies: 7
    Last Post: 10-14-2010, 04:23 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