Reading Excel to Database

Results 1 to 2 of 2

Thread: Reading Excel to Database

  1. #1
    Join Date
    Dec 1969

    Default Reading Excel to Database

    I have some Excel files. They all have the same structure. I don&#039;t need all the data from the files. I need the ability to loop line by line and check specific fields. For example loop to a record and get a social security number. Then add records to my database for values that are associated with that SSN.<BR><BR>Is there any objects that make it easy to read excel .xls files?<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default DTS

    for SQL Server... you can import from an Excel spreadsheet.

Posting Permissions

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