Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    database creation

    Hi,
    I have several excel files that are quotes for different parts for customers. They are all setup the same with the info I want out in the same cell position in each spreadsheet. is there any way to pull the info I want out of all the spread sheets at once to create some type of database so that I can use the data easier? HELP!

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    It depends a bit on what database you are working on.
    This works in DB2 and Infromix.
    You must create a table for your customers with the same amount of fields you defined in your excel sheet.
    Save your sheet as a comma-delimited file.
    Load it into the database.
    informix:
    load from 'file.csv' DELIMITER ','
    insert into customers

    With DB2 you could use the load and import command.
    Check with 'db2 ? load'.
    rws

  3. #3
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    I think in SQL Server you can create a DTS package that will read an excel file into the database.

    You can Import Excel files into Access but i'm not sure how do do this automatically - (manual method = File -> Get external Data)

  4. #4
    Join Date
    Jul 2002
    Location
    India
    Posts
    13
    As Wingman said,

    You can create a DTS package in SQL Server and save the package in the server itself. You can schedule it if the importing of data from excel to Database happens very frequently.

    You can have one more DTS package to export the data from SQL Server to Excel also.
    Balaji

Posting Permissions

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