HELP! Can't upload

Results 1 to 3 of 3

Thread: HELP! Can't upload

  1. #1
    Join Date
    Dec 1969

    Default HELP! Can't upload

    I want to upload a tab seperated text file into a SQL table using ASP or COM. I have looked through different sites and I can&#039t seem to find an answer. Help!!

  2. #2
    BAHEK Guest

    Default RE: HELP! Can't upload

    There is probably a way to do it with some sort of SQL Server tool, but you always can do it manually.<BR><BR>In your ASP script open the file. Read it line by line. Parse each line and execute an SQL insert statement or use Recordset object and add record by record.<BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: HELP! Can't upload

    There would be alot approaches for that. One you could create and open an ADO recorset from the file and open one from the SQL database then loop through the fields and rows transferring data.<BR><BR>Or just put the file into a multi dimension array using Join function then loop through that using an Insert statement Executed through a connection object.<BR><BR>or as in the first way create an ADO recordset. Loop through it creating an insert Statment from each row and execute them in a connection object

Posting Permissions

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