Importing large text csv files from msaccess to sql

Discussion in 'Databases' started by ch99, May 10, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. ch99

    ch99

    I am importing ms access data via the CSV import utility in the myLittleSql manager, but when I try to import the data from a text file (comma delimited)that is more than 1 MegaB in size, it times out with the ASP time out error. Wondering if there is anyway around this in myLittleSQL manager.
    thankx
    ch99

    Post Edited (ch99) : 5/10/2007 3:18:48 AM GMT
     
    ch99, May 10, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    No. I don't think so.

    Do you have Enterprise Manager installed? You may want to use SQL import / export wizard.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, May 10, 2007
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page