SQL Basics
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Tutorialized Forums > Databases > SQL Basics
Reload this Page

Excel into SQL

Discuss Excel into SQL in the SQL Basics forum on Tutorialized.
Excel into SQL SQL Basics forum covering the Structured Query Language standard. SQL is a common language recognized by many RDBMS software packages, that is designed to be a robust method for addressing the data stored in a database.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old November 16th, 2004, 02:07 PM
LLX LLX is offline
Senior Member
Tutorialized Newbie (0 - 499 posts)
  
Join Date: May 2004
Location: Glendale, CA
Posts: 285 LLX New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via AIM to LLX Send a message via MSN to LLX
Excel into SQL
Was wondering if their was a way to convert/inport excel data files into a MYSQL DB
__________________
24y-CW, 8y-HTML, 5y-PS, 8m-PHP
And I never knew Photoshop could do HTML!
You learn something every day.

http://lexxboard.lurkerlordx.com/listcatagories.php
Reply With Quote
  #2  
Old November 16th, 2004, 02:46 PM
kurt kurt is offline
Administrator
Tutorialized Novice (500 - 999 posts)
  
Join Date: Jan 2004
Posts: 514 kurt New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: 5 m 48 sec
Reputation Power: 0
Sure, open the file in excel, save it as a CSV or Tab Delimited file, and import that file. You could even write a perl script to do all of that for you.
Reply With Quote
  #3  
Old November 16th, 2004, 02:55 PM
LLX LLX is offline
Senior Member
Tutorialized Newbie (0 - 499 posts)
  
Join Date: May 2004
Location: Glendale, CA
Posts: 285 LLX New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via AIM to LLX Send a message via MSN to LLX
tanks (and some munitions as well)
Reply With Quote
  #4  
Old November 16th, 2004, 07:13 PM
LLX LLX is offline
Senior Member
Tutorialized Newbie (0 - 499 posts)
  
Join Date: May 2004
Location: Glendale, CA
Posts: 285 LLX New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via AIM to LLX Send a message via MSN to LLX
php my admin isnt seeming to import the file do you think i could have it configured wrong?
Is it posiblei could send you a sampel of my cvs file to seei f exel converted it incorectly...or mabe im just not looking in the right place to impost a csv file
Reply With Quote
  #5  
Old November 16th, 2004, 08:51 PM
kurt kurt is offline
Administrator
Tutorialized Novice (500 - 999 posts)
  
Join Date: Jan 2004
Posts: 514 kurt New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: 5 m 48 sec
Reputation Power: 0
Try it with a tab delimited file.

When you import with phpMyAdmin it gives options about the field delimiters. With a tab delimted file the delimiter is \t
Reply With Quote
  #6  
Old November 17th, 2004, 12:11 PM
LLX LLX is offline
Senior Member
Tutorialized Newbie (0 - 499 posts)
  
Join Date: May 2004
Location: Glendale, CA
Posts: 285 LLX New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via AIM to LLX Send a message via MSN to LLX
thanks

seems to work for the most part but my early test really set the auto icrement value high is their a way to reset the primary key increment value to re count from 0 on ann the fields
Reply With Quote
  #7  
Old November 17th, 2004, 06:26 PM
kurt kurt is offline
Administrator
Tutorialized Novice (500 - 999 posts)
  
Join Date: Jan 2004
Posts: 514 kurt New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: 5 m 48 sec
Reputation Power: 0
truncate the table.
Reply With Quote
Reply

Viewing: Tutorialized Forums > Databases > SQL Basics > Excel into SQL

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


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
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.