November 27, 2009 at 1:13 am
Hi every body
Can anyone help me to guide how can i import data from excel file to mysql table. My senior told me that this can be done by converting excel sheat into query and then execute that query into mysql database/ SQL Server.. but don't know how to create query fro that. So please tell me how can I do so?? Because my senior is not helping me.
Please tell me how can do so in sql server. then I will manage it in mysql.
Thank you
November 27, 2009 at 2:21 am
Did you try asking this question in a MySql forum?
It's more than likely that you won't be able to use the SQL Server solutions you might get here.
On the other side, you might get lucky to find someone dealing with mysql as well. But that's not the main purpose of this forum...
Because my senior is not helping me.
What is the reason for his/her decision? Is it a test how far you'll get on your own?
November 27, 2009 at 6:19 am
I found an "ODBC Connector for Windows". I have used that to pump data out of, and in to MySQL. If you want to pump data into SQL Server, I would use DTS or SSIS depending on the version that you use.
Andrew SQLDBA
November 27, 2009 at 12:44 pm
If your goal is to import data from an Excel source for one off time, then you can use Import / Export wizard available in SQL Server.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 27, 2009 at 1:01 pm
Bru Medishetty (11/27/2009)
If your goal is to import data from an Excel source for one off time, then you can use Import / Export wizard available in SQL Server.
I don't think so... he's looking for import into mysql, not SQL Server...
November 27, 2009 at 1:05 pm
lmu92 (11/27/2009)
Bru Medishetty (11/27/2009)
If your goal is to import data from an Excel source for one off time, then you can use Import / Export wizard available in SQL Server.I don't think so... he's looking for import into mysql, not SQL Server...
I think so, coz he said so.
amitsingh308 (11/27/2009)
Hi every bodyCan anyone help me to guide how can i import data from excel file to mysql table. My senior told me that this can be done by converting excel sheat into query and then execute that query into mysql database/ SQL Server.. but don't know how to create query fro that. So please tell me how can I do so?? Because my senior is not helping me.
Please tell me how can do so in sql server. then I will manage it in mysql.
Thank you
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 27, 2009 at 2:07 pm
Bru Medishetty (11/27/2009)
I think so, coz he said so.amitsingh308 (11/27/2009)
Hi every bodyCan anyone help me to guide how can i import data from excel file to mysql table.
....
Please tell me how can do so in sql server. then I will manage it in mysql.
Thank you
Oooopss... you're right! :blush:
However, when reading his first post again it gets confusing what the OP is really looking for. Seems like asking for mysql at the beginning, add SQL in between and remove mysql at the end. Strange way of asking for help... 😉
November 27, 2009 at 2:37 pm
This is at least strange way, there are others who have posted weird ways of asking help ...:-)
You don't know whether they are seeking suggestion, making a challenge or making statement ....
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 27, 2009 at 2:43 pm
Well, I probably have to use some math in the future to figure out what the post is about.
In this case it would be something like:
[import data from excel file from] + [mysql] + [sql server] - [mysql]
Result:
import data from excel file from sql server. 🙂
November 27, 2009 at 2:47 pm
How about this MySQL Server 😛
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 27, 2009 at 3:07 pm
Bru Medishetty (11/27/2009)
How about this MySQL Server 😛
Wouldn't be a valid result of the equation...
Btw: Adding a simple space to your suggestion would turn it into "My" SQL Server which is slightly different 😀
I guess I'll step back until the OP clarifies.... :Whistling:
November 27, 2009 at 4:29 pm
I wan't replying MySQL Server as a result of your equation.
I was suggesting a new phrase that's it..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 30, 2009 at 4:09 am
hello sir actualy I am working on MySQL dbms. n I know in SQL Server we can import data from excel sheat. but someone told me we can do so by useing query then i tried to do so with load file syntax bt i didn't help me so I wana to know is there any way we can import data from excel to sql by generating/ writing a sql script.
November 30, 2009 at 4:30 am
amitsingh308 (11/30/2009)
hello sir actualy I am working on MySQL dbms. n I know in SQL Server we can import data from excel sheat. but someone told me we can do so by useing query then i tried to do so with load file syntax bt i didn't help me so I wana to know is there any way we can import data from excel to sql by generating/ writing a sql script.
huh.. this is fun... you are still not clear where you want to do this... 'MySQL' or 'SQL Server'?
If its mySQL sorry, its very less likely that you will get a response here since its a SQL Server forum. If its SQL Server that you are looking for, go through this link. You have a variety of ways, I guess 'OPENQUERY' is what you need.
http://support.microsoft.com/kb/321686
---------------------------------------------------------------------------------
November 30, 2009 at 4:44 am
please tell me how to do so in mysql dbms. other wise give any url for mysql forums.
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply