Welcome Guest ( Log In | Register )



 
 Reply to this topicStart new topic
> Mysql Database Entry By Excel Sheets
Kian Mike
post Jul 9 2008, 03:54 PM
Post #1


Newbie [ Level 1 ]
Group Icon

Group: Members
Posts: 1
Joined: 9-July 08
Member No.: 31,381
Hello ..

I would like to ask if i can use use Microsoft excel files in order to make entries to mysql database.

Thanks
Go to the top of the page
 
+Quote Post
Darasen
post Jul 9 2008, 11:12 PM
Post #2


Advanced Member
Group Icon

Group: [HOSTED]
Posts: 133
Joined: 3-April 08
From: Milling about
Member No.: 29,596
Yes, you can use ADO to create an ODBC connection between an excel spreadsheet and MySQL. It may even be a bit easier to import the excel data into Access and then use the data connection and querying abilities of Access.

Alternately you can export your Excel data to a CSV file and use the tools in MySQL to import the data file.

Go to the top of the page
 
+Quote Post
darkken
post Jul 24 2008, 09:53 AM
Post #3


Newbie [ Level 2 ]
Group Icon

Group: [HOSTED]
Posts: 26
Joined: 2-July 08
Member No.: 31,263
you can use phpMyAdmin too if you have php enabled server
Go to the top of the page
 
+Quote Post
« Next Oldest · Databases · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL Output Database Question(18)
  7. MySQL, Multiple Tables(24)
  8. Navcat For MySQL(8)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Login System Using A Mysql Db(5)
  12. Mysql - So Hard(14)
  13. Mysql Problem(1)
  14. Connecting To A Remote Database(9)
  15. Database(1)
  1. Sun Bought Mysql(6)
  2. Integrate Access Database Onto Intranet Site(5)
  3. Mysql Backup With Another Address?(4)
  4. I Have An Error With My Mysql Connection(7)
  5. Accessing Ms Access Database From A Centralized Location?(5)
  6. Mysql And User File_priv(0)
  7. Mysql Database Management(1)
  8. Mysql On Computer(9)
  9. Space Needed For Database(10)
  10. Database Access On Remote Server W/jsp(0)
  11. Any Website Provide Free Host Mysql Host?(4)
  12. Mysql Multiple Tables(1)
  13. Some Useful Database Links.(7)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 5th September 2008 - 12:51 PM
Powered By IP.Board 2.2.1 © 2008  IPS, Inc.
Licensed to: Xisto Corporation