> I have taken a Microsoft Access database and have basically copied the
> structure of it and rebuilt it in MySQL, however, I have encountered
> some problems with formatting of data. I need to ask what is the most
> suitable field type to use to retain the content from Access field types
>
> The
I have taken a Microsoft Access database and have basically copied the
structure of it and rebuilt it in MySQL, however, I have encountered
some problems with formatting of data. I need to ask what is the most
suitable field type to use to retain the content from Access field types
The MS A
> The only way to link tables in MySQL (to use the term from Access) is to
> use the Federated database engine. A Federated table physically exists on
> one server but virtually exists on another. This is exactly like creating
> a linked table.
>
> However, AFAIK, the Federated database engine only
"Bing Du" <[EMAIL PROTECTED]> wrote on 04/04/2006 12:20:23 PM:
> Hello everyone,
>
> Please correct me if my understanding is wrong. Does the implementation
> of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
> Database Tables to Access?"
> (http://dev.mysql.com/doc/refman/4.1
Hello everyone,
Please correct me if my understanding is wrong. Does the implementation
of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
Database Tables to Access?"
(http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that
data is actually stored in MySQL and tab
Rodney,
Did you EVER get a response to your question ?
Im keenly interested to know the answer.
M i l e s
+++
President & Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.magicmiles.com/
[EMAIL PROTECTED]
aim/yahoo/msn: magi
I am new to MYSQL and I want to set-up a database with two or more tables that
need to be "linked". I come from a basic MS Access background, and in Access
linking two tables is done by creating a relationship. Is it done the same
way in MYSQL? If so, could someone please shed some light on this
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote:
There was some discussion in December of converting MS Access
databases to Mysql and the DBManager program was recommended.
I have recently converted access to mysql. I used access to import a
CSV file and ensured all data was in
There was some discussion in December of converting MS Access databases to
Mysql and the DBManager program was recommended. I have DBManager running
and select "Tools=>Data Management=>Import/Export Wizards," but the
command is greyed out and won't activate. I am using Office 2000 and I
have m
ssues?
Thanks again
Arthur
-Original Message-
From: Thomas Trutt [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: AW: Convert MS Access to MySql
question... does anyone know how it sets up the indexes, security
preferences , relation
://www.dbtools.com.br/EN/dbmanagerpro.php
There is a wizard which can do this conversion for you
Freddie
> -Ursprüngliche Nachricht-
> Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 21. Dezember 2003 19:00
> An: [EMAIL PROTECTED]
> Betreff: Convert MS
003 19:00
> An: [EMAIL PROTECTED]
> Betreff: Convert MS Access to MySql
>
> I need to convert an MS Access database to MySql. I would
> like to know the best way to do this. I was going to write an
> asp or php script that would read the MS Access db row by row
> and inser
: Sunday, December 21, 2003 11:00 AM
To: [EMAIL PROTECTED]
Subject: Convert MS Access to MySql
I need to convert an MS Access database to MySql. I would like to know
the best way to do this. I was going to write an asp or php script that
would read the MS Access db row by row and insert into the MySql db
Arthur
On converting data from MS Access. I've done this several times myself, and
found the easiest way is to:
1. Create your mySQL database tables
2. Define a DSN (ODBC Connection) from your workstation to the mySQL
database
3. Link the mySQL tables into your MS Access database
4. Copy the conte
<[EMAIL PROTECTED]>
Sent: Sunday, December 21, 2003 2:30 PM
Subject: Convert MS Access to MySql
> I need to convert an MS Access database to MySql. I would like to know the
> best way to do this. I was going to write an asp or php script that would
> read the MS Access db row by row an
I need to convert an MS Access database to MySql. I would like to know the
best way to do this. I was going to write an asp or php script that would
read the MS Access db row by row and insert into the MySql db row by row. Is
that the only way to move the data from the one db to the other?
Many th
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "mc 02" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, Januar
Hi Bob hall,
I do apologize for being unclear in my previous message.
To answer your question:
>Does the MySQL server run on your FreeBSD system?
Yes MySQL runs prefectly with my FreeBSD 4.6 system.
> How are you trying to export your Jet tables? I assume that's
what you mean when you refer
AIL PROTECTED]>
Subject: RE: Connection ms access to mysql
> What errors are you seeing when you try to perform the
export?
--
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signu
On Fri, Jan 17, 2003 at 03:15:05AM -0500, mc 02 wrote:
> I've downloaded the necessary application MySQL 3.51 and myODBC for
> freeBSD. On the XP side i only downloaded myODBC. I played around the
> configuration but i still cant seem to export the files to my FreeBSD
> box.
>
> What am i doing w
Hi,
I'm New to the networking world so bare with me. Now i know im
suppose to look through the manual in the mysql website but i still
cant make it work. So i need all the help i can get.
What i want to do:
===
I want to export my MS Access (2000) files (.mdb)in my WinXP Box to
M
At 04:12 PM 11/30/02, you wrote:
I've pretty much resigned myself to writing some kind of script to manually
export these records using some kind of unique record delimiter, but I
thought I'd check and see if anyone has any other better ideas on how to get
my data transferred.
You'll find all ki
I'm very new to mysql and haven't got much of a background in databases
generally, so thanks in advance to any who have the patience to deal with my
question.
I'm trying to get data from ms access 97 to mysql by exporting to a text
file then using the "load data" command to import it.
The data in
ry [mailto:kewl@;compfort.pl]
> Sent: Tuesday, 12 November 2002 22:02
> To: [EMAIL PROTECTED]
> Subject: RE: How to port MS Access to MySQL ??
>
>
>
> MyODBC works fine,
> but what to do if you have hundreds of tables?=20
>
> its painf
MySQLFront will create the tables and pump the data with one button
press
Alan
> -Original Message-
> From: Terry [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 12 November 2002 22:02
> To: [EMAIL PROTECTED]
> Subject: RE: How to port MS Access to MySQL ??
>
>
MyODBC works fine,
but what to do if you have hundreds of tables?=20
its painful job, maybe theres some
easier way to do that ?
regards,
terry
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
John Ragan [mailto:jragan@;arkansas.net]
Enviado el: domingo, 10 de noviembre de 2002 2:58
Para: [EMAIL PROTECTED]; stefano.scattini
Asunto: Re: I: How to port MS Access to MySQL ??
although i make a living from their products and
corereader runs under windows, i really really
hate to give macrosoft a pl
e 2002 13.18
> A: [EMAIL PROTECTED]
> Oggetto: How to port MS Access to MySQL ??
>
> Is there a tool for doing a quick port from MS Access
> to MySQL?
>
> Or must you manually create all the tables & sql
> statements in MySQL and then export the MS Access data
> to a comma d
I use navicat http://www.mysqlstudio.com/.
ing. stefano scattini
-Messaggio originale-
Da: tmb [mailto:topmailbox@;yahoo.com]
Inviato: venerdì 8 novembre 2002 13.18
A: [EMAIL PROTECTED]
Oggetto: How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access
age-
> > From: tmb [mailto:topmailbox@;yahoo.com]
> > Sent: Friday, 8 November 2002 23:18
> > To: [EMAIL PROTECTED]
> > Subject: How to port MS Access to MySQL ??
> >
> >
> > Is there a tool for doing a quick port from MS
> Access
> > to MySQL?
> >
> &
Petre,
Where do I get MyOdbc ??
Does it run on linux?
thanks - tmb
--- Petre Agenbag <[EMAIL PROTECTED]> wrote:
> myodbc works fairly OK for me.
>
> On Fri, 2002-11-08 at 14:17, tmb wrote:
> > Is there a tool for doing a quick port from MS
> Access
> > to MySQL?
age-
> > From: tmb [mailto:topmailbox@;yahoo.com]
> > Sent: Friday, 8 November 2002 23:18
> > To: [EMAIL PROTECTED]
> > Subject: How to port MS Access to MySQL ??
> >
> >
> > Is there a tool for doing a quick port from MS
> Access
> > to MySQL?
> >
&
MySQLfront does it all
> -Original Message-
> From: tmb [mailto:topmailbox@;yahoo.com]
> Sent: Friday, 8 November 2002 23:18
> To: [EMAIL PROTECTED]
> Subject: How to port MS Access to MySQL ??
>
>
> Is there a tool for doing a quick port from MS Access
>
Yep, ODBC works great.
Make a connection from Access to MySQL and mirror the access db into MySQL.
STIBS
> myodbc works fairly OK for me.
>
> On Fri, 2002-11-08 at 14:17, tmb wrote:
> > Is there a tool for doing a quick port from MS Access
> > to MySQL?
> >
> >
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 10:17 AM
Subject: How to port MS Access to MySQL ??
> Is there a tool for doing a quick port from MS Access
> to MySQL?
>
> Or must you manually create all the tables & sql
> statements in MySQL
myodbc works fairly OK for me.
On Fri, 2002-11-08 at 14:17, tmb wrote:
> Is there a tool for doing a quick port from MS Access
> to MySQL?
>
> Or must you manually create all the tables & sql
> statements in MySQL and then export the MS Access data
> to a comma delimited
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create all the tables & sql
statements in MySQL and then export the MS Access data
to a comma delimited file... then import it into
MySQL?
Thanks for any help -
Have a look at MyAccess available from http://www.accessmysql.com it has
worked for me
Alex
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 09:14
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion
We have a Unix server which in addition to
We have a Unix server which in addition to running MySQL is also a
fileserver for a group of MS Windows PCs (using samba) and it would be
useful to be able to convert the Microsoft Access .mdb files put there
by users directly to MySQL, or at least to .csv format.
Does anyone know of such a utili
Hi All,
I'm trying to connect ms access to a mysql server that I installed on my
Linux machine. I already downloaded the MyODBC 2.50 which is required to
connect to mysql using ms access. My problem is when I try to connect the
database in ms access to the mysql server I get the error "Host not a
Fabio Amura <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 1:33 PM
Subject: ....from ms access to mysql
> Hi,
> i have to migrate from ms access to my sql, and i dont know how can i
do...
> do your know at easy metod for this migration, and can
Hello,
Look on the following page: www.dbtools.com.br.
There is a good software which can handle that task.
- Original Message -
From: "Fabio Amura" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 8:33 AM
Subject: from ms acces
Hi,
i have to migrate from ms access to my sql, and i dont know how can i do...
do your know at easy metod for this migration, and can you give me
indication or link
i'm not an espert...
thanks
fabio
-Messaggio originale-
Da: Jochen Kaechelin [mailto:[EMAIL PROTECTED]]
Inviato: giove
Mark,
Saturday, January 26, 2002, 11:58:47 PM, you wrote:
MS> What about converting MySQL data to Oracle ?
In general, mysqldump will help.
MS> Mark
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
At 14:58 -0700 1/26/02, Mark Stringham wrote:
>What about converting MySQL data to Oracle ?
There's something for this somewhere on Oracle's web site.
That's all I know, never used it.
-
Before posting, please check:
http://
Subject: Re: Converting MS Access to MySQL
>You're right Paul thoses product are realy good, thanx for theses
>information.
>
>theOtherOne
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Ed Lazor" <[EMAIL PROTECTE
IL PROTECTED]>
Sent: Saturday, January 26, 2002 10:10 AM
Subject: Re: Converting MS Access to MySQL
>
> At 9:59 -0800 1/26/02, Ed Lazor wrote:
> >At 12:51 PM 1/26/2002 -0800, you wrote:
> >>I Scotland,
> >>
> >>It's not the first t
At 9:59 -0800 1/26/02, Ed Lazor wrote:
>At 12:51 PM 1/26/2002 -0800, you wrote:
>>I Scotland,
>>
>>It's not the first time i give this adress:
>>http://www.urbanresearch.com/software/utils/urbsql/
>>
>>Hope This Help ;)
>>
>>theOtherOne
>
>It looks like urSQL allows you to view data from various d
At 12:51 PM 1/26/2002 -0800, you wrote:
>I Scotland,
>
>It's not the first time i give this adress:
>http://www.urbanresearch.com/software/utils/urbsql/
>
>Hope This Help ;)
>
>theOtherOne
It looks like urSQL allows you to view data from various database
formats. Does it handle data conversion
4 AM
Subject: Converting MS Access to MySQL
>
> Hello again all,
>
> Greetings from Scotland.
>
> Can anyone direct me to where I can get some free software which will
> convert an MS Access database to My SQL.
>
> Thanks,
>
> James Oliver
>
>
> -
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
http://www.mys
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
http://www.mysq
I need to convert ms access to mysql.
Has anyone done this successfully ??
thanks
=
Regards,
Investorclb
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
Steve, Doug & Gordan,
Thanks for taking the time to help me.
Billy
- Original Message -
From: "Steve Rapaport" <[EMAIL PROTECTED]>
To: "Billy Reed" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 2:17 AM
Subject: Re:
pilot. Subsequent code writes this to a new table showing who is in the
> lead !!
>
> Can anyone suggest how this is done in MySQL. It doesnt seem to like the TOP
> 5 syntax.
>
> I have been able to convert the rest of my site from MS Access to MySQL but
> am s
On Thursday 27 Dec 2001 23:31, Billy Reed wrote:
> I am new to MySQL and am trying to convert :
>
> SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague
> WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
>
> Can anyone suggest how this is done in MySQL. It doesnt see
lots (for a specific pilot) and then sums the result for
each pilot. Subsequent code writes this to a new table showing who is in the
lead !!
Can anyone suggest how this is done in MySQL. It doesnt seem to like the TOP
5 syntax.
I have been able to convert the rest of my site from MS Access to MySQL bu
I'm running MS Access DB roughly 30K records with several users accessing it
at the same time (that's what worries me the most) so I'm looking into
moving to some SQL server.
I have tried exporting the tables and still using the access forms as a GUI
through ODBC.
I tested MSDE, MS SQL, mySQL whic
: Monday, October 22, 2001 5:12 PM
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL, but I need to know how to
import or convert Access database to MySQL. ANyone know how I would go
about that? Also this is for a web site and I need to
in mySQL. Congratulations.
- Jonathan
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:12 PM
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL, but I need to know how to
try this:
http://www.mysql.com/downloads/contrib.html#SEC653
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:12 PM
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL, but
I am new to this fast database and love MySQL, but I need to know how to
import or convert Access database to MySQL. ANyone know how I would go
about that? Also this is for a web site and I need to change the asp
code to PHP. Its not a lot, only a few pages, but its a headache for
someone that
Hi,
I have an access database in MSAccess 2000 and I am trying to
export tables into mySQL database. I can import tables in MSAccess
but cannot export table.
When I try to export the table , I get the following error:
ODBC--call failed.
[Microsoft][Gestionnaire de pilotes ODBC ]
Type d'informati
Sent: Friday, July 13, 2001 9:21 PM
Subject: exporting tables from MS access to mysql
> Hello,
>
> I have made an access database in MSAccess 2000 and I am trying to
> export tables into mySQL database. The problem is, I can export tables
with
> numbers but cannot export table w
Hello,
I have made an access database in MSAccess 2000 and I am trying to
export tables into mySQL database. The problem is, I can export tables with
numbers but cannot export table with "text" or anything. When I try to
export the table with a "text" column, I get the following error:
OD
d Luck,
Dennis
**
Beridney Computer Services
http://www.beridney.com
- Original Message -
From: "Thompson, Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 10:37 AM
Subject: VBA/VB DAO/ADO MS Access to MySQL?
> Howdy,
>
> I cu
This works fine from VB6. Install the MyODBC driver (get it from the
MySQL web site), then set up a datasource just as you usually would.
Ideally, you won't have to change any of your VB code - just bind the
ADO/DAO controls to the MySQL datasource rather than the Access
datasource.
Note that
rol to the backend...
Good Luck.
ChrisB
MCSE MCDBA
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:14 AM
To: Thompson, Mike; [EMAIL PROTECTED]
Subject: Re: VBA/VB DAO/ADO MS Access to MySQL?
Yes it can, via ODBC.
I've never done it t
Yes it can, via ODBC.
I've never done it though. (I don't work in VB)
Cal
- Original Message -
From: "Thompson, Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 12:37 PM
Subject: VBA/VB DAO/ADO MS Access to MySQL?
Howdy,
I currently have an application which uses DAO and ADO coding in VBA/VB as
well as databound objects in VB to access a MS Access database. Can DAO and
ADO in VBA/VB and databound objects in VB be made to work with a MySQL
database?
Anybody done this successfully?
Cheers,
Mike
[EMAIL PROTECTED] writes:
> Hello MySQL,
>
> We are a company that is considering a change to the MySQL database.
>
> Due to the fact that we got a lot of MS-access databases around here we want
> to ask you about the possibilities to converte MS-access databases to mySQL.
>
> I m interested in
Hello MySQL,
We are a company that is considering a change to the MySQL database.
Due to the fact that we got a lot of MS-access databases around here we want
to ask you about the possibilities to converte MS-access databases to mySQL.
I m interested in the bugs that is known ( loosing datatype
At 8:37 AM +0700 5/4/01, Taing Nguon wrote:
>Dear Sir/Madam
>
> I just know that there is a tool to convert database from MS Access
>to Mysql, But I do not know the URL of this tool. Could you tell me this
>URL? Thanks
Check this page and look in the "converters" se
Dear Sir/Madam
I just know that there is a tool to convert database from MS Access
to Mysql, But I do not know the URL of this tool. Could you tell me this
URL? Thanks
Regards
Taing Nguon
-
Before posting, please check
Now I have a java application which connect to MS Access, I want to use MySQL
instead, how can I transfer all the tables and data into MySQL? should I use MyODBC
to replace JDBC-ODBC driver?
Thank you for any help!
Forest
-
B
;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 8:23 PM
Subject: linking ms access to mysql db
> question:
>
> Can i link to a mysql database using ms access 97 or ms access 2000 using
an
> odbc driver.
> i recall doing it before, but can'
question:
Can i link to a mysql database using ms access 97 or ms access 2000 using an
odbc driver.
i recall doing it before, but can't seem to get it work again. i would
appreciate any help
you could give me on this subject. thanks
charlie scott
-
77 matches
Mail list logo
