PDA

View Full Version : database creation

4herbert
08-27-02, 13:13
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!
Roelwe
08-28-02, 05:45
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'.
WingMan
08-30-02, 06:01
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)
pcmbalaji
12-03-02, 02:10
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.