Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.7. This is a maintenance
release for 1.3.x. It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts
to very easily access
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.6. This is a maintenance
release for 1.3.x. It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts
to very easily access
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.5. This is a maintenance release for 1.3.x.
It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.4. This is a maintenance release for 1.3.x.
It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.3. This is a maintenance release for 1.3.x.
It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can
be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.1. This is a RC release for 1.3.x.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and manipulate MySQL data within Microsoft Excel
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.0. This is a beta release for 1.3.x.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and manipulate MySQL data within Microsoft Excel
The MySQL Windows Experience Team is proud to announce the release of MySQL for
Excel version 1.2.1. This is a maintenance release for 1.2.x.
MySQL for Excel is an application plug-in enabling data analysts to very easily
access and manipulate MySQL data within Microsoft Excel. It enables
Hi
I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work
5% of my job with SQL but I am searching for a full time SQL job.
http://shop.oreilly.com/product/0790145363466.do
Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a
junior SQL pro job? What do
Hi,
I have a fairly standard set of queries that I do then I save the resultset as
a CSV and send it off to a couple dozen folks. My understanding is that I can
build an Excel .iqy file that can do the queries (one for each query) and that
I need send that file but once to the users. Does
Thanks for your information, we are sorry about this.
- Original Message -
From: Martin Gainty
To: pagong...@gmail.com ; haidarpes...@gmail.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, August 04, 2010 6:20 AM
Subject: RE: from excel to the mySQL
Vaz
lecture
Hi!
Data Wizard for MySQL allows you to import data from Excel (as well as
from CSV, DBF, XML and text files) in a few mouse clicks. The app also
provides a flexible task scheduler.
http://www.sqlmaestro.com/products/mysql/datawizard/
- Original Message -
From: HaidarPesebe haidarpes
Thanks for your information, we have tried it and solve my problems.
Thanks.
- Original Message -
From: Miguel Vaz
To: HaidarPesebe
Cc: MySQL Lists
Sent: Wednesday, August 04, 2010 1:40 AM
Subject: Re: from excel to the mySQL
Hi,
Ive always used navicat for mysql
Dear All,
I'm needs a way to upload data from excel to the mySQL database. Dear all, I
need help is how to upload data from excel columns and load into mysql database
using php?
Thanks
HaidarPesebe
I'm needs a way to upload data from excel to the mySQL database. Dear all, I
need help is how to upload data from excel columns and load into mysql
database using php?
http://www.sqldbu.com/eng/sections/tips/mysqlimport.html
--
MySQL General Mailing List
For list archives: http
visit this site :
http://www.daniweb.com/forums/thread119197.html
--- On Tue, 8/3/10, Marc Guay marc.g...@gmail.com wrote:
From: Marc Guay marc.g...@gmail.com
Subject: Re: from excel to the mySQL
To: HaidarPesebe haidarpes...@gmail.com
Cc: MySQL Lists mysql@lists.mysql.com
Date
hi HaidarPesebe,
one way to do this is :
1. save the excel to xxx.csv
2. then use the mysql SQL statement LOAD DATA INFILE
for example :
LOAD DATA INFILE 'c:\\test\\xxx.csv'
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
best regards
liuyann
From: haidarpes...@gmail.com
Hi,
Ive always used navicat for mysql and it does wonders for import/export
(wether it be from excel or any other file type) and also general database
management. Actually, too many features to list here, check the website:
http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html
+0100
Subject: Re: from excel to the mySQL
From: pagong...@gmail.com
To: haidarpes...@gmail.com
CC: mysql@lists.mysql.com
Hi,
Ive always used navicat for mysql and it does wonders for import/export
(wether it be from excel or any other file type) and also general database
management
Vikram A wrote:
Hi,
I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this?
There are several ways to get structure information from within MySQL:
the SHOW COLUMNS... command
the SHOW INDEXES... command
the SHOW CREATE TABLE... command
use can use mysqldump with option *-no-data*
eg.
*mysqldump -u user -ppassword wordpress user --no-data Dumpdata.txt *
where wordpress is my database and user is my table.
Thanks
On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Vikram A wrote:
Hi,
I would
Note : if you table name it will export all tables from given database;
eg:*
mysqldump -u user -ppassword wordpress --no-data Dumpdata.txt *
It will export all tables from db wordpress.
On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar aim.prab...@gmail.comwrote:
use can use mysqldump with
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A vikkiatb...@yahoo.in
wrote:
Hi,
I would like to export my table structure from MYSQL from a particular
db.
Is there any tool for doing this?
Please guide me.
Thank you
VIKRAM A
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A vikkiatb...@yahoo.in wrote:
Hi,
I would like to export my table structure from MYSQL from a particular db.
Is
2010 08:18
To: Vikram A
Cc: MY SQL Mailing list
Subject: Re: Mysql - Tables Export to Excel!
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A vikkiatb...@yahoo.in wrote
Or MySQL Connector :)
On Apr 8, 2010 10:11 AM, Carsten Pedersen cars...@bitbybit.dk wrote:
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A vikkiatb...@yahoo.in
wrote:
Hi,
I would like to export my table structure from MYSQL from a particular
db.
Is
Hi,
I would like to export my table structure from MYSQL from a particular db. Is
there any tool for doing this?
Please guide me.
Thank you
VIKRAM A
Hi all,
I would like to know if there is a tool or command in mySQL that allows one to
export the result of query into excel formart
ishaq gbola wrote:
Hi all,
I would like to know if there is a tool or command in mySQL that allows one to
export the result of query into excel formart
select * from table into outfile thefile.txt;
That can be imported into excel using CSV and using TAB as separator.
http
You can use the --xml option to the mysql command to get xnl output. You
can also get a tab-delimited output file that can be read into Excel (this
is what I usually do).
To get a tab-delimited file, you can use the --tab option of mysqldump or
start up the mysql program with the -sss option
Thanks a lot for that, but where does this file get saved in and how can i copy
it to my local host if the database is on a remote server
--- On Tue, 5/1/10, Jay Ess li...@netrogenic.com wrote:
From: Jay Ess li...@netrogenic.com
Subject: Re: Exporting the result of a Query into excel
To: mysql
ishaq gbola wrote:
Thanks a lot for that, but where does this file get saved in and how can i copy
it to my local host if the database is on a remote server
If you don't specify the absolute location it can be find in
DATADIR/DatabaseName/. And after you located the file you have a
: Exporting the result of a Query into excel
Thanks a lot for that, but where does this file get saved in and how can i copy
it to my local host if the database is on a remote server
--- On Tue, 5/1/10, Jay Ess li...@netrogenic.com wrote:
From: Jay Ess li...@netrogenic.com
Subject: Re: Exporting
...@gmail.com wrote:
From: sureshkumar...@gmail.com sureshkumar...@gmail.com
Subject: Re: Exporting the result of a Query into excel
To: ishaq gbola ishaq...@yahoo.co.uk, mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:37
Hi
What is the OS you are using on the remote and local server
trial.txt' at line 1
mysql
--- On Tue, 5/1/10, Jay Ess li...@netrogenic.com wrote:
From: Jay Ess li...@netrogenic.com
Subject: Re: Exporting the result of a Query into excel
To:
Cc: mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:35
ishaq gbola wrote:
Thanks a lot for that, but where
Ok. In windows, Use winscp tool, connect to the server and copy the file to
local machine and import it in excel.
Thanks
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: ishaq gbola ishaq...@yahoo.co.uk
Date: Tue, 5 Jan 2010 13:42:20
To: mysql@lists.mysql.com
Subject
We have to use outfile with select stmt, not with show.
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: ishaq gbola ishaq...@yahoo.co.uk
Date: Tue, 5 Jan 2010 13:45:44
To: mysql@lists.mysql.com
Subject: Re: Exporting the result of a Query into excel
As test i tried
...@netrogenic.com
Subject: Re: Exporting the result of a Query into excel
To: mysql@lists.mysql.com Mysql mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:22
ishaq gbola wrote:
Hi all,
I would like to know if there is a tool or command in mySQL that allows
one to export the result
not to use a msqlclient for it, that it could break the database???
--- On Tue, 5/1/10, sureshkumar...@gmail.com sureshkumar...@gmail.com wrote:
From: sureshkumar...@gmail.com sureshkumar...@gmail.com
Subject: Re: Exporting the result of a Query into excel
To: ishaq gbola ishaq...@yahoo.co.uk, mysql
Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a tab-delimited
file mytab.txt might be:
mysql -e'select * from mydb.mytab' -sss mytab.txt
The -sss
Carsten:
Can you demonstrate this?
~Lawrence
Carsten Pedersen wrote:
Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a
tab-delimited
file
, 2010 at 1:50 PM, Carsten Pedersen cars...@bitbybit.dkwrote:
Is there any particular reason not to use the MySQL ODBC driver to import
the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a tab-delimited
file mytab.txt might
-Original Message-
From: ishaq gbola [mailto:ishaq...@yahoo.co.uk]
Sent: Tuesday, January 05, 2010 7:18 AM
To: mysql@lists.mysql.com
Subject: Exporting the result of a Query into excel
Hi all,
I would like to know if there is a tool or command in mySQL that allows
one
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
Save the excel file as a CSV text file, then use LOAD DATA INFILE
command to import. See the mysql manual for usage and example.
On May 8, 2008, at 4:49 AM, Lord Gustavo Miguel Angel wrote:
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
--
MySQL General
I have created table in mysql with 12 fields
Field1Field2 Field3 Field4
Field12
I have an excel sheet with 12 columns and 150 rows.
My question is how can I import all of the columns from the excel sheet to my
table without losing any information
Hi, sam
You can try to export table to file from Excel in CSV format.
And then import data from this file to mysql.
Something like this should help you:
LOAD DATA INFILE 'yourtabledata.txt' INTO TABLE yourtable FIELDS
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n';
sam rumaizan
hello .
anybody knows how to export from excel to mysql in order to create or fill a
database table??
tanks for your help and patience
cheers
Sure, it's usually fairly straightforward to transfer data. You can
export to a CSV or other delimited file, then use MySQL's LOAD DATA
INFILE command to read it in. See
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
I haven't ever tried creating tables from something in Excel
If you have the Max Binaries of MySQL, do the following:
1) Export Excel Data to a CSV file (mydata.csv)
2) Goto MySQL and create table, without indexes to
accept the data (CREATE TABLE myImportCSV)
3) Change the table layout to accept CSV
i.e., ALTER TABLE myImport ENGINE = CSV;
Please note
, if needed. Position yourself at cell A1.
2. Using Excel functions, build an entry like
=CONCATENATE(INSERT INTO mytable SET col1 = ,'Sheet1'!A1,, col2 =
,'Sheet1'!A2, ...)
You can use Excel's click to build the cell links to the other
spreadsheet, you don't have to type them by hand
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 18, 2006 8:37 AM
To: MySQL List
Subject: excel and Mysql?!
hello .
anybody knows how to export from excel to mysql in order to
create or fill a database table??
tanks for your help and patience
cheers
--
MySQL General Mailing List
Always being the last to input, there are lots of other
database tools out there that let you do this.
One in particular is DBTools Professional (which is what I use). You can ADO
IMPORT Excel, MS-Access, and others like FoxPro and PostgreSQL.
Another is Database Workbench
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Saturday, December 10, 2005 5:17 PM
Subject: RE: from MySQL to MS Excel ...
There is at least one other option that JR didn't mention... at least some
versions of Excel have the menu option
C.R.Vegelin wrote:
Thanks JR, Shawn, Scott, ... for your replies.
I choose to make use of the SELECT ... INTO OUTFILE.
This works fine, but I also want a header-line in the CSV file.
So I made the following statement:
SELECT `ID`, `Code`, `Name`
UNION
SELECT `ID`, `Code`, `Name` INTO OUTFILE
Here's the skinny -- YES and NO.
NO in that it won't export directly, YES in that you have to do a little leg
work in order for it to be done.
You have 3 options -- ODBC, Code and CSV.
ODBC -- Excel has the ability to use ODBC connections to the MySQL database.
Run your MySQL query
There is at least one other option that JR didn't mention... at least some
versions of Excel have the menu option Data-Get External Data which
allows you to link through ODBC to run queries directly from within Excel.
I have barely used it and I have never tried it with MySQL so I can't
really
numbers with me, after scrubbing
against the dnc registry, i get back results for 3000 numbers which means 1000
numbers have to be deleted from the list of 4000, how do i do this, can i get
this done in excel.,
pls help.
regards
Parker
--
Sent from the MySQL - General forum at Nabble.com:
http
i want to put a value in a column that is the date of today .
IS there a solution to do that in sql way ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this may help you
test create table d (
- date date );
Query OK, 0 rows affected (0.45 sec)
test insert into d values(now());
Query OK, 1 row affected (0.12 sec)
test select * from d;
++
| date |
++
| 2005-09-10 |
++
1 row in set (0.00 sec)
On
On Error Goto 0
cn.Close
Set rs = Nothing
Set cn = nothing
--End Code--
HTH,
Arjan.
-Original Message-
From: Nick Jones [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 08:23 PM
To: mysql@lists.mysql.com
Subject: Populate values in an Excel sheet from MySQL
Does anyone know
Hi,
I had to do the same thing on a project and the problem was that if
you use CSV you will not be able to make a formated excel document.
I am using now *Spreadsheet_Excel_Writer
/package/Spreadsheet_Excel_Writer (
*http://pear.php.net/package/Spreadsheet_Excel_Writer ) and it does
Thanks to all for your help. I solved my problem the
quick and dirty way. Here's what I did:
1. Created my Excel spreadsheet to look the way I
wanted it, saved it as an XML spreadsheet.
2. Used PHP to pull the desired data from the MySQL
server on our iSeries machine.
3. PHP writes the XML data
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You Yahoo!?
Tired
Automatically populate??
Not that _I_ know of, but of course there are those on this list that know
much more than I.
I do know that you can export the values into tab delimited format and then
import it into Excel.
I think that you may want to do this via ASP or PHP. It would make life a
lot
Nick Jones wrote:
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into tab
delimited format and then
import it into Excel.
I think that you
into tab
delimited format and then
import it into Excel.
I think that you may want to do this via ASP or PHP.
It would make life a
lot easier.
J.R.
PHP would definitely be the way to go on this. I'm
working on a web application running on our AS/400
here running Apache, PHP
Nick Jones wrote:
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into tab
delimited format and then
import it into Excel.
I
ContentType (or similar call) =
application/vnd.ms-excel
3) (optional) Write PHP echo strings for adding XML tags. (You can find
these at http://msdn.microsoft.com, although I'll be damned if I can find
them now. Ask for them and I will get them from my other computer and send
them on.)
4
into tab
delimited format and then
import it into Excel.
I think that you may want to do this via ASP or
PHP.
It would make life a
lot easier.
J.R.
PHP would definitely be the way to go on this. I'm
working on a web application running on our AS/400
here running Apache, PHP
if you want to use excel i suppose you have also windows with more than 3 GO
free disk.
install win32 mysql
put the files in the data directory of one existing database
connect and use that database
export data to an outfile by :
select * from yourtable into outfile csv fields terminated
No, I don't have Windows.
I need some one to load my tables, export to excel and email me the
excel docs.
On Jun 7, 2005, at 11:54 PM, [EMAIL PROTECTED] wrote:
if you want to use excel i suppose you have also windows with more
than 3 GO
free disk.
install win32 mysql
put the files
I recently received some old database files from my ISP. I'm trying to
convert the documents to excel format. When I try to load the .frm,
.MYI and .MYD files on my OS X MySQL databases I get the following
error.
#5 - Out of memory (Needed 3024898224 bytes)
Unfortunately I can't work
[snip]
Don't be so hasty to criticise. I took the original question to mean
While I have an existing spreadsheet open in EXCEL, can I cause a
selected
row in a MySQL table to be updated?. This is quite a different
question
than How can I convert one sheet from an EXCEL file into a new MySQL
Is it possible to write to a MySQL table from Excel?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One problem I've encountered in the past creating CSV files from Excel is with
fields that exceed 256 or 258 characters. The fields end up truncated in the
CSV file. A script to directly access the data in Excel and move it to MySQL is
appropriate, but can be a lot of work if you only need
[snip]
Is it possible to write to a MySQL table from Excel?
[/snip]
Sure.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 03:12 PM 4/22/05, Jay Blanchard wrote:
[snip]
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
[/snip]
You must be new to mailing lists too...
http://catb.org/~esr/faqs/smart-questions.html
You can save the excel
[snip]
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
[/snip]
You must be new to mailing lists too...
http://catb.org/~esr/faqs/smart-questions.html
You can save the excel as a CSV file and import
Get a beginners book then rather than posting messages.
-Original Message-
From: Huang, Ou [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 5:17 PM
To: Jay Blanchard; mysql@lists.mysql.com
Subject: RE: Write to a mysql table from Excel
Oh well, I am just not smart as you
Oh well, I am just not smart as you are. Sorry, I am a new comer in the
Geek's world.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 3:12 PM
To: Huang, Ou; mysql@lists.mysql.com
Subject: RE: Write to a mysql table from Excel
[snip]
Thank
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 3:00 PM
To: Huang, Ou; mysql@lists.mysql.com
Subject: RE
Hello,
I have a mysql ODBC driver 3.51.11.00 installed on a xp machine in order
to connect to mysql server (on unix) remotely via the ODBC driver. The
ODBC driver was working well. What I am trying to do is to import one of
the mysql table into excel through New Database Query option in Excel
Fargo Services
-Original Message-
From: Huang, Ou [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 1:33 PM
To: mysql@lists.mysql.com
Subject: Error when importing mysql table into excel via ODBC
Hello,
I have a mysql ODBC driver 3.51.11.00 installed on a xp machine in order
Hi Dan,
Sorry for causing additional work to getting the test setup, I will take
your advice should I need to post these type of details again
With regards to your solution, it works perfectly!!! Great thanks for
putting the time and effort in to help sort this problem. Much appreciated.
I
Hey Dan,
Thanks for the post and the code ideas. Unfortuantely I still can't get the
thing to work even when trying the CONCAT and CAST functions.
As per your request, here is the details of what I have got so far:
I'm running MySQL 4.1.9 with MyODBC 3.51. The table in question is the Users
Dan Wareham wrote:
Hey Dan,
Thanks for the post and the code ideas. Unfortuantely I still can't
get the thing to work even when trying the CONCAT and CAST functions.
As per your request, here is the details of what I have got so far:
I'm running MySQL 4.1.9 with MyODBC 3.51. The table in
Hello,
I have a table in my database with two fields set as Time types.
The issue I seem to have is when I use an ADO connection in VBA for Excel to
select the two fields.
Instead of the expected format HH:MM:SS held within my recordset, I get the
current date in the format DD/MM/
Dan Wareham wrote:
Hello,
I have a table in my database with two fields set as Time types.
The issue I seem to have is when I use an ADO connection in VBA for
Excel to select the two fields.
Instead of the expected format HH:MM:SS held within my recordset, I
get the current date in the format
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NaviCat
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Steve Grosz [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 2:56 PM
To: mysql@lists.mysql.com
Subject: Import Excel data
PM
To: mysql@lists.mysql.com
Subject: Import Excel data into table
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Steve Grosz [EMAIL PROTECTED] writes:
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
If your data is a .csv file [a.csv] similar to:
1,Steve,Grosz
2,Brad,Eacker
Consistent with the output from Excel. You could use
LOAD DATA
I forgot one element
LOAD DATA LOCAL INFILE 'a.csv' INTO TABLE Users
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
(id,firstName,lastName);
Brad ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Florida's First ISP
- Original Message -
From: David Ziggy Lubowa [EMAIL PROTECTED]
To: Eric Bergen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 6:54 PM
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way
PROTECTED]
Sent: Wednesday, December 08, 2004 6:54 PM
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load
]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 6:54 PM
Subject: Re: Excel 2 mysql
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use
David Ziggy Lubowa wrote:
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote:
On Wednesday 08 December 2004 05:07, Patrick Sherrill wrote:
David,
Please provide the complete LOAD DATA INFILE command you used.
mysql -e LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE
1 - 100 of 215 matches
Mail list logo