If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Chit Chat > database creation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-27-02, 12:13
4herbert 4herbert is offline
Registered User
 
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!
Reply With Quote
  #2 (permalink)  
Old 08-28-02, 04:45
Roelwe Roelwe is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 08-30-02, 05:01
WingMan WingMan is offline
Registered User
 
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)
Reply With Quote
  #4 (permalink)  
Old 12-03-02, 01:10
pcmbalaji pcmbalaji is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On