Reply
Dumb as a rock!
Old 01-02-2008, 02:43 PM Dumb as a rock!
Junior Talker

Posts: 1
Name: Paul Bylin
Please excuse my dumb-ness (if that's even a word), but I am as dumb as a rock when it comes to database stuff. However, I am going nuts trying to do something.

I have multiple files in Windows Excel format (xls) that I would like to put into a searchable database and use it as a program (a not for sale program, but to freely distribute to whom ever would like it)

Now for the dumb question... is there a program (software) that I can "dump" this xls info into and save it to a searchable database?
Pauley is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
     
Old 01-02-2008, 07:21 PM Re: Dumb as a rock!
mgraphic's Avatar
Truth Seeker

Posts: 2,282
Name: Keith Marshall
Location: West Hartford, CT
Depends on what type of database and server-side language you can run on your website. For example, using phpMyAdmin is excellent for importing CSV data into a MySQL database on a PHP enabled system.
__________________

<mgraphic /> - I don't have a solution but I admire the problem.
mgraphic is offline
Reply With Quote
View Public Profile
 
Old 01-02-2008, 10:36 PM Re: Dumb as a rock!
ForrestCroce's Avatar
Half Man, Half Amazing

Posts: 3,025
Name: Forrest Croce
Location: Seattle, WA
If you're using asp, you can actually query the Excel file directly using SQL, as if it were a database. The OleDb Provider makes things easy enough.

All versions of Excel can write csv - comma separated values - files. New versions can also write xml files. Either one can be imported into most databases. How you go about it depends on which one you use.
ForrestCroce is offline
Reply With Quote
View Public Profile Visit ForrestCroce's homepage!
 
Reply     « Reply to Dumb as a rock!
 

Thread Tools

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

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




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 5.12157 seconds with 13 queries