Post reply

Creating new table and importing data from a CSV file

  • February 6, 2008 at 11:10 am

    #186347

    Hi,

    We have a main users table in our database. We get a list of users from our partners, in a CSV format, with matching fields as our main users table.

    We would like to create an aspx page where admin users can go in, input a new table name and upload the CSV file. In the backend I want to create a new table, (same schema as our main users table) and import all the rows from the uploaded CSV file into this new table. Any suggestions? We are using ASP.Net 1.1 and SQL Server 2000.

    Thanks

  • February 6, 2008 at 11:46 am

    #775727

    you can create a package and then call the package passing the file name and path *** input parameters. Also try using bulk insert option. There are other options too like opendatasource, etc where you can import your csv to a sql table.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 6, 2008 at 5:49 pm

    #775823

    Will it work from inside an aspx page? The csv file will be uploaded from an aspx web form.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply