Results 1 to 2 of 2
  1. #1
    adnancanada is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    121

    How to import data from Excel to SQL Server


    I am running a pass through query to get details of POs. I am using MS Access 2013 backend is SQL server. Query runs fine through odbc connection. but I have list of POs in Excel sheet how can I link them. Kindly help

    select * from PO detail where PONbr = (Excel file PONbr)

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You can link to an Excel spreadsheet just like you can like to an Access database.

    Since you have spaces in object names, you must enclose the names in brackets
    Code:
    select * from [PO detail] where PONbr = (Excel file PONbr)
    If the "Excel file PONbr" is text, it will need to be delimited in quotes.



    Without more info or examples of the SS, can't give a better answer.



    Is this a one time operation?

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

Similar Threads

  1. Replies: 2
    Last Post: 06-25-2015, 03:56 PM
  2. Replies: 3
    Last Post: 01-05-2015, 02:21 PM
  3. Import access query data into excel file, using excel vba
    By exceljockey in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2013, 02:36 PM
  4. Import excel data to sql server programatically using ms access
    By selvakumar.arc in forum Import/Export Data
    Replies: 3
    Last Post: 04-29-2013, 08:32 AM
  5. Import data from Excel
    By mari_hitz in forum Import/Export Data
    Replies: 1
    Last Post: 06-13-2011, 07:34 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