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 > Database Server Software > MySQL > turn this excel file, into a searchable database on my website (was "complete n00b")

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-17-07, 14:08
slanderizer1 slanderizer1 is offline
Registered User
 
Join Date: Jan 2007
Posts: 1
turn this excel file, into a searchable database on my website (was "complete n00b")

Hi,

I'm a complete n00b to databasing. I mean i know very little to nothing. I have a rather large excel file that i want to turn into a database, i've cleaned it up and organized it but thats about it so far. My goal is to turn this excel file, into a searchable database on my website. My webhost provides MySQL. I know nothing about where to even start building a database, i dont know if i can import it into mysql or anything. The only thing ive tried so far with no success is importing the excel file into microsoft access. I dont even know how to make tables or anything. Basically, what i'm looking for, is any tutorials, guides, manuals, anything that will teach beginning databasing, basically from scratch to a complete and total noob. If you have any resources like this, please please please send them my way. Thank you very much for taking the time to help, and have a great day!

Reply With Quote
  #2 (permalink)  
Old 01-17-07, 16:02
snorp snorp is offline
Registered User
 
Join Date: Apr 2004
Location: Europe->Sweden->Stockholm
Posts: 71
Actually, I would recommend that you read the first few chapters of the MySQL manual. You'll rather easily find it at mysql.com. The first chapters of the manual is more or less like a tutorial; it shows you how to create tables, insert values in them and so on. After you've learned this, you'll eventually stumble upon the LOAD DATA INFILE command.

Install MySQL and follow the examples. Within a few hours, you'll probably understand the basics and you'll be happy that you spent your time. Knowing some basic SQL is good for anyone handling more than just a tiny bit of information, IMHO
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