Computers & Internet Logo

Related Topics:

Posted on Feb 20, 2009

Import data to excelsheet insert in mysqltable query

  • Anonymous May 11, 2010

    where is the data you want to import from

×

2 Answers

Anonymous

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

  • Contributor 3 Answers
  • Posted on Mar 22, 2010
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Joined: Mar 21, 2010
Answers
3
Questions
1
Helped
440
Points
4

Mysql export to excel

you should have a mysql admin i use phpmyadmin from there you click on export to csv and i also select the display headers in file there should also be a save file as box to select.
then save to local hard drive
find the file and right click open with excell it should import automatically




Anonymous

Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 6 Answers
  • Posted on Sep 21, 2009
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

Joined: Sep 21, 2009
Answers
6
Questions
0
Helped
1656
Points
8

You can save it as csv and use the file to insert using
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Anabel smith - noted expert spammer on FIXYA - may have an Indian connection from other postings. How do I change my password on Yahoo, sbcglobal mail

Sbcglobal service is one of the important services used for personal or business purposes where we easily transfer our data from one place to another without any hesitation. This email service has the finest importance of the standard emails. You can get important data within few minutes at your place. One of the excellent services is Sbcglobal Phone Number. We resolve many of queries of our users which they face. Our best team of the technician will resolve your query within a limited period of time and you get relevant solutions. So, contact here: 1-833-284-2444 when you face any kind of glitch. I assure you to get relevant solutions at your cost.

Website: https://www.contactxpert.com/sbcglobal-email-phone-number.html
0helpful
1answer

Drive makes clicking noise

See clicking, grinding or any unwanted type of noise is a clear indication of physical hard drive failure so, if you have very important data stored in your drive then you should take an immediate assistance from the data recovery professional. In physical hard drive failure you shouldn't delay as it can damage your hard drive more severely and can make you to loose your data for for forever. But if you consult a data recovery expert on time for sure you will be able to save and get back your data. If any other query drop a reply.
0helpful
1answer

I have a memory card ..which have some importent data but problem is that when i insert the card in drive to copy its show that do you want to formate the card ...plz help me i dont wann lost my data

try to insert that card to other unit or gadget, or if that not possible buy if you dont have a card reader have it connected to usb of your pc, then copy important files / document on it. at least you already save that files to your pc.
0helpful
1answer

How to transfer Nokia phone SD card information such as contact list to Samsung GT-B3410 micro SD card?

try using this solution
at first import contacts from nokia sd by inserting in your handset and importing it from samsung pc studio
after that insert your samsung sd card in your handset
and export your contacts from samsung pc studio
Jun 09, 2010 • Cell Phones
2helpful
3answers

How to automatically import data from tally to excel. Want to display auto imported data in sharepoint.

Import TALLY Data / Export TALLY Data
Tally allows users to Import data from other software's as well as Export data from Tally to other software's. Tally allows users to Import and Export in ASCII, SDF and XML formats. XML is now the most widely used format of exporting data in the world. Any transactions can be exported from Tally and imported in other software after suitably altering the current structures to accept Tally data structure. The reverse is also possible by writing a small TDL program to accept the data from other software's. The data that is to be imported into Tally can be in either XML or DBF format. Easy Tally data transfer or Tally data migration from Tally 4.5 & Tally 5.4 to Tally 6.3 , Tally 7.2 , etc.
ODBC COMPLIANCE ALLOWS OTHER PROGRAMS TO USE DATA FROM TALLY DIRECTLY. E.G. : MS-EXCEL :
ODBC - OPEN DATABASE CONNECTIVITY
Tally is now ODBC compliant. Hence, any program like MS-Excel, Oracle etc that is ODBC compliant can use data from Tally. Here, data connectivity is dynamic i.e. any new updation in Tally is reflected in other ODBC Compliant Software immediately. Now, with ODBC facility the user can extract data out of Tally and design his own report formats in other ODBC compliant software's.
Procedure :
Now, Load Company -> specify period -> minimize Tally -> Open a new Excel file -> select data -> select 'Get External Data' -> select New database query -> choose Data Source
Tally connects to data source and displays Tally Wizard query screen -> select the columns you would want to include in the query.
Once all the columns are selected, the user returns to excel and excel displays all the columns selected
Graphical Analysis of Tally Data
Sometimes, pictures can say better than figures. Tally also provides graphical (Bar graph) analysis of data. The user can do a graphical analysis reports like Sales register, Purchase register, Ledgers, Funds flow, Cash flow, Item registers etc. This helps the user in deeper analysis of data. In Tally, a graphical analysis can also show month wise graphs for the year in comparison with any other period. This will help the management in quickly locating the highs and lean periods in a financial year and hence be better prepared for difficult times.
Web Enabled
Tally ees 6.3 is now Web enabled. This will help the user in reducing his paper work further. Now, report in Tally can be e-mailed directly from Tally. It is not just reports, but even invoices and purchase orders can also be e-mailed directly from Tally. Hence, the user does not have to send printed invoice or purchase orders from Tally.
Procedure :
Select any report (e.g. Balance sheet) -> select Alt+M (E-mail) -> specify all details as required by Tally
Ability to Publish Reports and Documents on the Internet
Now, Tally allows users to upload reports on the web site directly from Tally. So companies that would want to publish reports on the web site can do so directly from Tally. Many companies would also like to publish their price list on their websites along with the product they deal with.
Procedure :
Select any report (Profit and Loss A/C) -> select Upload (Alt + O) -> specify all details as required by Tally.
Direct Internet Access
Tally now offers direct Internet access. A Tally user while working on Tally can directly log on to tally website get details of all the facilities offered by Tally. The user can also download the latest releases of Tally 6.3 as and when available. Tally website also offers a facility of Tally Chat. Any user can now chat with a Tally representative and get any information regarding Tally.
Procedure :
Start Tally -> now, from any screen select Web Browser (Alt+W). Tally now takes you to the Tally Web site.
Print Preview
Any user would ideally like to view format of reports / Invoices / Vouchers before printing the same. Tally now offers a facility of print preview. Now any report can be viewed before printing or before it is mailed. Once Tally shows the preview the user can either opt to print or mail the same.
1helpful
1answer

Hi, I need to Import Outlook Express Emails (that were on another PC - and the Maintenance / Store location from express has been backed up to an external hard drive) and import the mail and contacts into...

Hi,

You ought to copy the Ms Outlook Data file that is usually stored in your computer containing all your outlook data.

To locate it:
  • open my computer on the current computer that has the addresses and files.
NB: Make sure that you have enabled viewing of hidden files in your computer. Do this by going to the

  • Tools on the Menu bar --------- Folder Options----------Click on the View Tab ---------on the Advanced settings ------File and Folders -----Turn on Show Hidden files and Folder on the Hidden Files and Folders Menu.

Open Drive on Drive C:

  • On C: follow this sequence to open the file
  • C:/-----Documents and Settings--------Click on the User Account-----Local settings-------Application Data------Microsoft-----------Outlook.

When you are here you will see the Outlook Office Data File.

  • Copy this Outlook Office Data File in a removable media e.g Memory Stick.
Now you have copied the E-Mail and Addresses File.

  • Go to the computer you wish to copy the E-Mails, Settings and Addresses.
  • Open Microsoft Outlook Program
  • Under the File Menu Click on the Import and Export submenu.
An Import and Export Wizard dailog box opens up.

  • From the Action to perform choose
  • Import Internet Mails and Addresses and click next.
  • The Outlook Import tool dialog opens.
  • Select the Internet Mail Application to Import from: Choose on Outlook Express 4.X, 5.X, 6.X making sure that the Import Mail, Import Address Book , Import rules Options are turned on.
  • Click next
  • Address Dialog Box Opens up
  • choose on the option accordingly and click finish
  • Browse for Folder dialog box opens up.
  • Select the location of your saved Ms Outlook Data file
  • Click OK
  • Starts to import all your E-mail files and Addresses to the new computer.
Thats it. I guess you have your mails and Addresses.

Incase of any queries please dont hesitate to ask.

Kind Regards,
Picofly
0helpful
1answer

My excel sheet is opeaning very slow about 30 40 sec

there could be several reasons for that:
1. do you have links pointing to another excel/website/folder/db query? if so- it is probably trying to import data from it. the most common is to try and import data from another excel sheet- you need to have that excel open before you open this on
2. what is the size of your excel file? if it's big- try to see if you can break it to several excel sheets.
3. what type of hardware do you have? do you have enough memory?

can you provide more details?

0helpful
1answer
0helpful
1answer

Query for retrieve the data

so, are you looking for the query statement to get this info...

And, upon entering the 6th digit, your code will execute the sql query, such as:
SELECT cardnumber from <table_name> where cardnumber>='123456'

NOTE: replace <table_name> with the name of your table.

You might have to modify the statement depending upon how your calling it.

Check out more info at http://www.w3schools.com/sql/sql_where.asp

Hope this helps.
4helpful
4answers

Running SQL queries on Excel

Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth
Not finding what you are looking for?

196 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...