Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Location
    Epsom, United Kingdom
    Posts
    42

    Unanswered: BULK INSERT and Access2000 data

    Hi there,

    Is it possible to use BULK INSERT to import data from an Access2000 table to an SQL Server table?

    Thanks in advance.
    Shadow to Light

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    BULK INSERT works with SQL Server and use DTS to import data from Access database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Location
    Epsom, United Kingdom
    Posts
    42
    Originally posted by Satya
    BULK INSERT works with SQL Server and use DTS to import data from Access database.
    I know that you can use DTS! That's what I've been using all the time but I am interested to know whether it is possible to do it in T-SQL instead.

    Thanks for your suggestion though!
    Shadow to Light

  4. #4
    Join Date
    Jul 2002
    Location
    IA
    Posts
    28
    I've done it if the Excel is saved as a CSV file.
    Thanks,
    Jason

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •