mdbtools-dev

[mdb-dev] Import MDB to MySQL

[Jurgen at M. <ju...@ma...>]

Hi,

Has anyone already solved this problem? I'm looking to simply scoop all 
the data from an MDB file and dump it into a MySQL database (or 
whatever SQL, really, I just want to get this stuff into a real 
database so I can do something useful with it :-) ).

Thanks in advance!

......jurgen

---------------------------------------------------------------
Jurgen Schaub                           ju...@ma...
Marketcom Pty Ltd                  http://www.marketcom.com.au/
Melbourne                                          03 9510 1544
---------------------------------------------------------------

[mdb-dev] I've tried to use libmdb, but I have problem with compilation.

[Czastkiewicz J. <cza...@su...>]

Hallo Everybody!

I've installed mdbtools and mdbtools_dev and wrote a simple program:

/* test.cpp */
#include <mdbtools.h>

int main() {
        mdb_init();
        return 1;
}
/* end test.cpp */

And I tried to compile:

g++ -o test test.cpp -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include -lmdb
/tmp/ccy48EO7.o(.text+0x11): In function `main':
: undefined reference to `mdb_init()'
collect2: ld returned 1 exit status

Where is the problem? What more I should include?

I have libmdb.so in /usr/lib and mdbtools.h in /usr/include, so it should
work.

Thanks you.

Jacek Czastkiewicz

PS
Are there any version of ,,MDB Tools Programmer's Guide'' now ?

Re: [mdb-dev] seeking help in Ms Access

[Mukesh K. <muk...@ya...>]

Thanks tony,
could you please give me an example to fetch data from
to files "c:\a.mdb" having table table_Name_a
and "c:\b.mdb" having table_name_b

Thank you
Mukesh Kumar
muk...@ya...





Note: forwarded message attached.


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: [mdb-dev] seeking help in Ms Access

[Tony T. <tt...@mv...>]

At 09:20 PM 2003/10/27 -0800, Mukesh Kumar wrote:

>I'm not sure whether my problem has any affirmative
>solution but trying to be sure for that.

I'm not at all sure this is the correct forum to answer your question as 
your question seems to have nothing to do with MDB Tools.

If others deem then off topic then please ask your question in a newsgroup 
appropriate to your subject such as microsoft.public.access.queries.  If 
you are unfamiliar with how to use a newsgroup reader you can visit the 
Microsoft Product Support Newsgroups online at 
http://support.microsoft.com/newsgroups/default.aspx.  Click on Office, 
Access and then the appropriate newsgroup to review current postings and 
post your own question.

 >Sometime I require to fetch some data with some condition
 >from a database say "A" and in the same query fetch some
 >data from another database say "B".

One approach might be to created linked files in  mdb "A" pointing to files 
in mdb "B".

Alternatively you would want to use the IN clause.  FROM tableexpression 
IN  "C:\folder name\B.mdb"

There may be some limitations such as
"You can use IN to connect to only one external database at a time."

Alternatively you might want to consider appending tables to a temporary 
MDB and then running your queries against that temporary MDB.

Tony

-----
Tony Toews, Microsoft Access MVP
Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm

[mdb-dev] seeking help in Ms Access

[Mukesh K. <muk...@ya...>]

Hallo Everybody,

I'm not sure whether my problem has any affirmative
solution but trying to be sure for that.

My problem is

I've more than 5 database in MS Access
I require to fetch some information from each database

Sometime I require to fetch some data with some
condition from a database say "A" and in the same
query fetch some data from another database say "B".

So the query may be like as follows
"select
Database_name_A.Table_Name_a.Column_name_aa,Database_name_A.Table_Name_a.Column_name_bb,Database_name_B.Table_Name_b.Column_name_aa,Database_name_B.Table_Name_b.Column_name_bb
from Database_name_B.Table_Name_b,
Database_name_B.Table_Name_b where clause"

Now database_name_A is in "c:\A.mdb", database_name_B
is in "c:\B.mdb"

I know this is possible in SQL server as the select
command is like
"select database.table.fields,database.table.fields
from database.table,databse.table where clause"

But the problem with MS Access is it creates one
databse with onle file. Means we cannot create
multiple database in a single MS Access file.

SO MY PROBLEM IS THERE ANY WAY TO CONSTRUE A SQL QUERY
TO EXECUTE MULTIPLE DATABASE (EACH DATABASE IS A 
SEPERTE FILE ON A LOCAL SYSTEM'S HARD DISK) IN MS
ACCESS?

Thanks you,
Mukesh Kumar

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

[mdb-dev] mdbtools core dump

[Robert T. <rt...@pa...>]

I have an MDB file with the following header:

00000000  00 01 00 00 53 74 61 6E 64 61 72 64 20 4A 65 74 ....Standard Jet
00000010  20 44 42 00 00 00 00 00 B5 6E 03 62 60 09 C2 55  DB......n.b`..U

 From reading the mdbtools code, the _mdb_open() routine will read 0x14 
into the first page of the file and get a "jet_version" value of 0 
(which defaults to Jet3).  I'm not sure what program generated the MDB. 
Do I have a really old MDB file that is not supported by mdbtools?  What 
does a "jet_version" of 0 mean?  The MDB tools are all core dumping.

Thanks for your help,

Rob

[mdb-dev] no longer works in 0.5

[<ham...@t-...>]

Hi there,

Changing from 0.5rc2 to 0.5 made mdbtools fail on one particular database
The attached patch (data.c, near line 406) gets the old behaviour back.
Here is also contributed mdb-pgexport tool which generates data suitable for
postgres "copy" command, with proper escaping and including null values
The patch adds null values to the library

Wolfgang Hamann

diff -r -u ../diff/mdbtools-0.5/include/mdbtools.h ./include/mdbtools.h
--- ../diff/mdbtools-0.5/include/mdbtools.h	Sun Jan 12 23:59:42 2003
+++ ./include/mdbtools.h	Mon Oct 27 09:15:58 2003
@@ -252,6 +252,7 @@
 	GPtrArray	*sargs;
 	GPtrArray	*idx_sarg_cache;
 	unsigned char   is_fixed;
+	unsigned char is_null;
 	int		query_order;
 	int		col_num;
 	int		cur_value_start;
diff -r -u ../diff/mdbtools-0.5/src/libmdb/data.c ./src/libmdb/data.c
--- ../diff/mdbtools-0.5/src/libmdb/data.c	Sun Jan 12 23:59:43 2003
+++ ./src/libmdb/data.c	Mon Oct 27 09:15:51 2003
@@ -350,6 +350,7 @@
 	int offset, 
 	int len)
 {
+	col->is_null = isnull;
 	if (col->col_type == MDB_BOOL) {
 		mdb_xfer_bound_bool(mdb, col, isnull);
 	} else if (col->col_type == MDB_OLE) {
@@ -403,7 +404,7 @@
 		map_pg = _mdb_get_int32(table->usage_map, i);
 		//printf("loop %d pg %ld %02x%02x%02x%02x\n",i, map_pg,table->usage_map[i],table->usage_map[i+1],table->usage_map[i+2],table->usage_map[i+3]);
 
-		if (!map_pg) continue;
+        if (!map_pg) {pgnum += (mdb->fmt->pg_size - 4) * 8; continue;}
 
 		if(mdb_read_alt_pg(mdb, map_pg) != mdb->fmt->pg_size) {
 			fprintf(stderr, "Oops! didn't get a full page at %d\n", map_pg);
--------------------------
new file src/util/mdb-pgexport.c

/* MDB Tools - A library for reading MS Access database file
 * Copyright (C) 2000 Brian Bruns
 *
 *
 * This library is free software; you can redistribute it and/or 
 * modify it under the terms of the GNU Library General Public
 * License as published by the Free Software Foundation; either
 * version 2 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Library General Public License for more details.
 *
 * You should have received a copy of the GNU Library General Public
 * License along with this library; if not, write to the
 * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
 * Boston, MA 02111-1307, USA.
 */

#include "mdbtools.h"

#define is_text_type(x) (x==MDB_TEXT || x==MDB_MEMO || x==MDB_SDATETIME)
main(int argc, char **argv)
{
int rows;
int i, j;
unsigned char buf[2048];
MdbHandle *mdb;
MdbCatalogEntry *entry;
MdbTableDef *table;
MdbColumn *col;
/* doesn't handle tables > 256 columns.  Can that happen? */
char *bound_values[256]; 
char *delimiter = ",";
int delim_len;
char header_row = 1;
char quote_text = 1;
char escape_text = 0;
char use_nulls = 0;
char use_copy = 0;
char *out_table = 0;
int  opt;

	while ((opt=getopt(argc, argv, "HQecnd:t:"))!=-1) {
		switch (opt) {
		case 'H':
			header_row = 0;
		break;
		case 'Q':
			quote_text = 0;
		break;
		case 'd':
			delimiter = (char *) malloc(strlen(optarg)+1);
			strcpy(delimiter, optarg);
		break;
		case 'e':
			escape_text = 1;
		break;
		case 'c':
			use_copy = 1;
		break;
		case 'n':
			use_nulls = 1;
		break;
		case 't':
			out_table = (char *) malloc(strlen(optarg)+1);
			strcpy(out_table, optarg);
		break;
		default:
		break;
		}
	}
	
	/* 
	** optind is now the position of the first non-option arg, 
	** see getopt(3) 
	*/
	if (argc-optind < 2) {
		fprintf(stderr,"Usage: %s [options] <file> <table> [postgres]\n",argv[0]);
		fprintf(stderr,"where options are:\n");
		fprintf(stderr,"  -H             supress header row\n");
		fprintf(stderr,"  -Q             don't wrap text-like fields in quotes\n");
		fprintf(stderr,"  -d <delimiter> specify a column delimiter\n");
		fprintf(stderr,"  -e             escape delimiter in text with \\\n");
		fprintf(stderr,"  -t <tablename> tablename for postgres output\n");
		fprintf(stderr,"  -c             add \"copy tablename from stdin\"\n");
		fprintf(stderr,"  -n             use \\N to output null values\"\n");
		fprintf(stderr,"specifying the postgres profile sets other options suitable for pg export\n");
		exit(1);
	}

	if(argc-optind > 2)
	{	header_row = 0;
		quote_text = 0;
		escape_text = 1;
		use_nulls = 1;
		use_copy = 1;
		delimiter = "\t";
	}

	mdb_init();

	if (!(mdb = mdb_open(argv[optind]))) {
		exit(1);
	}
	
	mdb_read_catalog(mdb, MDB_TABLE);

	for (i=0;i<mdb->num_catalog;i++) {
		entry = g_ptr_array_index(mdb->catalog,i);
		if (entry->object_type == MDB_TABLE &&
			!strcmp(entry->object_name,argv[optind+1])) {
			table = mdb_read_table(entry);
			mdb_read_columns(table);
			mdb_rewind_table(table);
			
        		for (j=0;j<table->num_cols;j++) {
                	bound_values[j] = (char *) malloc(MDB_BIND_SIZE);
				bound_values[j][0] = '\0';
                		mdb_bind_column(table, j+1, bound_values[j]);
        		}
			if (use_copy)
				fprintf(stdout, "copy %s from stdin\n", out_table ? out_table : argv[optind+1]);

			if (header_row) {
				col=g_ptr_array_index(table->columns,0);
				fprintf(stdout,"%s",col->name);
        			for (j=1;j<table->num_cols;j++) {
					col=g_ptr_array_index(table->columns,j);
					fprintf(stdout,"%s%s",delimiter,col->name);
				}
				fprintf(stdout,"\n");
			}

			delim_len = strlen(delimiter);
			while(mdb_fetch_row(table)) {
        		for (j=0;j<table->num_cols;j++) {
					if(j)
						fprintf(stdout, "%s", delimiter);
					col=g_ptr_array_index(table->columns,j);
					if (escape_text) {
						char *p = bound_values[j];
						if(use_nulls && col->is_null) p = "\\N";
						for( ; *p ; p++)
						{	if(strncmp(p, delimiter, delim_len) == 0)
								putchar('\\');
							putchar(*p);
						}
					} else if (quote_text && is_text_type(col->col_type)) {
						fprintf(stdout,"\"%s\"",bound_values[j]);
					} else {
						fprintf(stdout,"%s",bound_values[j]);
					}
				}
				fprintf(stdout,"\n");
			}
			if(use_copy)
				fprintf(stdout, "\\.\n");

        		for (j=0;j<table->num_cols;j++) {
				free(bound_values[j]);
			}
		}
	}

	mdb_free_handle(mdb);
	mdb_exit();
}

[mdb-dev] odbc with SunONE ASP

[Matt <ma...@ky...>]

Hi there,

I'm trying to get mdb-tools working with SunONE ASP on a RH7.3 box, but
not having a lot of luck. Has anyone else attempted this?

I have a sneaky feeling that SOASP doesn't use unixODBC and that's the
basic prob - it keeps it's own odbc.ini files etc in the install dir,
and no matter what I do to them I'm getting connection errors. Current
setup looks like:

[test]
Description = Test
Database=/path/to/database.mdb
Driver=/usr/lib/libmdbodbc.so.0
Setup = 
FileUsage = 1
CPTimeout =
CPReuse =
UserName =
Password =
Servername = localhost
Port = 5432 

This gives me an error like so in the log:
ADODB.Connection.1, 80004005, SQLState: 01000
Native Error Code: 0

If anyone's got any suggestions, it'd be great - I'm on the verge of
giving up!

M.

[mdb-dev] Unable to compile from CVS

[Luca M. <man...@ti...>]

Hi, 

I'm a new user of mdb-tools (the saved me the day this week). 
I'm now trying to get the sources (may be I'll do something useful).
I've got the CVS sources and tried to run ./autogen.sh, but it fails. 
The script is attached, any help is welcome.

	thanks, Luca

PS: I've tried also with the tarball (mdbtools-0.5.tar.gz), but there
    is a dependency on gtk. I just need the libs and the command line
    tools. Depending an a widget libreary seems too strong. Or not?

[mdb-dev] Password "Protected" MDB files

[Tim <ti...@te...>]

I have a few (JET4) MDB files that when I open with MS Access, it asks me for a
password (which I do not know).  However I can access the structure and
most of the data, without specifying a password, using mdbtools.

Is the password protection really this poor? Or is it just that some of the
tables that are password protected, and MS Access isn't smart enough to
let me access the unprotected tables?  Or is mdbtools just recovering
old data that was written to the file before a password was added?

There are also a few columns that don't come out right when I select
data from one of the tables.  I get "ff?fff" (for the CASENUM column in
the LoanAdditional table) instead of the correct "0001234567".  Kind of
like the offset is wrong or something.  I used mdb-dump and saw "ff?fff"
several bytes further in the page than the location of the correct data.

Maybe I should give you some of the data from one of the rows I know the
table contains (COLUMN: DATA):

FILENUM: DPI01005
CASENUM: 0001234567
SUFFIX: 703
SECTION: 203B

Here is the MDB file:

	http://tetro.net/misc/dpiv30.mdb

There is no sensitive data in it.  It is a demo data set from a piece of
software I'm working with.

Oh, and I'm using the Debian unstable mdbtools packages, version 0.5-6.

   - Tim

[mdb-dev] Runs as Root not as User (ODBC)

[Jonathan H. <jon...@bt...>]

Hi
I am trying to read access databases from php for a web interface.
Have installed mdbtools and gui and set odbc.ini to read a local mdb file,
all works well with isql 'MSAcess' as root, I can query the file and
withdraw info off it.
As soon as a log on as a normal user I get 'Data source name not found'
error.
I have set $ODBCINI and $ODBCSYSINI to point to /etc
I have checked permisions on all files and they seem ok
If I su to root it still does not work
If I log on as root and su to a normal user it also comes up with the same
error
But all the gui tools work as a user !!
Any Ideas???
Thanks in advance

Jonathan Hartley

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.520 / Virus Database: 318 - Release Date: 18/09/2003

Re: [mdb-dev] Basic questions

[David M. <mdb...@dm...>]

On 23 Sep 2003, Olivier Bourdon - Mataru wrote:

> Hello
> 
> I just dowloaded the latest available release of mdbtools (aka 0.5 dated
> 2003-01-18) as .tgz from sourceforge as well as did a cvs extract from
> the repository.
> However, looking at the archive of the mailing list, I saw
> quite a lot of [PATCH] announcements around April 11th which do not seem
> to be in either version
> Is it possible to grab the latest source tree from somewhere ?
> 
> Furthermore, I already did some changes in the source code of the tgz
> version because I found some small problems and wanted to do some
> enhancement of my own even if this piece of software is already very
> usefull.
> 
> Is there any process to follow so as to get those integrated into the official
> source tree if changes are considered interesting?
> 

Both the official maintainer and myself (author of said patches) seem to 
be too overworked to actually commit those patches and make a release.  
I've attached my 'combined' patch which has all my accumulated patches 
against the 0.5rc2 release.  

Good luck,

David

-- 
/==============================\
| David Mansfield              |
| mdb...@db...       |
\==============================/

[mdb-dev] Basic questions

[Olivier B. - M. <ol...@ma...>]

Hello

I just dowloaded the latest available release of mdbtools (aka 0.5 dated
2003-01-18) as .tgz from sourceforge as well as did a cvs extract from
the repository.
However, looking at the archive of the mailing list, I saw
quite a lot of [PATCH] announcements around April 11th which do not seem
to be in either version
Is it possible to grab the latest source tree from somewhere ?

Furthermore, I already did some changes in the source code of the tgz
version because I found some small problems and wanted to do some
enhancement of my own even if this piece of software is already very
usefull.

Is there any process to follow so as to get those integrated into the official
source tree if changes are considered interesting?

Thanks a lot and best regards.

Olivier

[mdb-dev] UTF-8 problems and non-ascii chars in table header

[Juan A. M. <jan...@di...>]

I've installed mdbtools-0.5.1 from rpms. Some mdb files show me
several problems:

In gmdb2 when data fields contains non 7bit-ascii ( ie =ED,=F1,=F3=20
and so ) lots of "non-UTF8 char" messages goes to terminal

When I try to export to postgres some tables there are also
problems on non-ascii table field names:
export data skips field name and provides only type:

CREATE TABLE mytable (
	-- This work as expected:
	nombre varchar(8),
	-- here should come field name "=EDndice" ( note the acute i),
	-- but mdb-export just simply skip field name:
		int4
);

So there are no way to export it :-(

In gmdb2 the effect on non-ascii named fields is that=20
field gets empty and no way to retrieve/view field data=20
on corresponding rows

Any suggestion will be appreciated. Thanks in advance

--=20
Juan Antonio Martinez <jan...@di...>
Dpto Ingenieria Telematica

[mdb-dev] Re: ODBC parse error

[<jms...@ai...>]

[English version]

Jos=E9:

Would tou try run 'isql' command, you can see its format, and a line
like this:
    cat Mysql | isql (DSN)

I see  you connect fine with ODBC, but you didn't write SQL command. You
could try write an command like this:
    # echo "select * from prestamos where nombre like '%La Biblia%'" |
isql biblio

Best regards

Josemi
------------------------

[Spanish version]

Jos=E9:

Si ejecutas 'isql' sin argumentos, comprobar=E1s que el formato es:
    cat Mysql | isql (DSN)

Por lo que est=E1s indicando, estableces la conexi=F3n, pero te falta
realizar la instrucci=F3n SQL. Tambi=E9n puedes hacerla de la siguiente m=
anera:
    # echo "select * from prestamos where nombre like '%La Biblia%'" |
isql biblio

Un saludo,

Josemi

Re: [mdb-dev] crypted MDB?

[David M. <mdb...@dm...>]

> Hi,
> 
> I recently received an mdb file that crashed mdb tools.
> I had a look at the file - there was some "standard jet database" in the header, but
> I could not find anything that looked like a file page, nor could I find any traces of the
> expected content, just binary garbage
> Access said that the "file can only be opened by members of the group that created it"
> or something similar.
> 
> Is there anything like a compressed or encrypted mdb file?
> 

It is possible for mdb files to be encrypted, but I've never seen them 
protected.  In other words, the encryption seems to just be an 
obfuscation, and anyone with Access can open the file.

You can try mdbtools-0.5rc2, patched with my 'combined patch' (attached) 
which adds the ability to unencrypt the mdb files, but you may be seeing 
some other kind of encryption.

David

-- 
/==============================\
| David Mansfield              |
| mdb...@db...       |
\==============================/

[mdb-dev] crypted MDB?

[<ham...@t-...>]

Hi,

I recently received an mdb file that crashed mdb tools.
I had a look at the file - there was some "standard jet database" in the header, but
I could not find anything that looked like a file page, nor could I find any traces of the
expected content, just binary garbage
Access said that the "file can only be opened by members of the group that created it"
or something similar.

Is there anything like a compressed or encrypted mdb file?

Wolfgang Hamann

Re: [mdb-dev] mdb-export problems

[David M. <mdb...@dm...>]

On Fri, 12 Sep 2003, Lane Stevens wrote:

> For starters, mdb-tools has been very helpful to me.  I appreciate the
> effort that has been devoted to create this suite of tools.
> 
> I have been experiencing some problems exporting tables.  The problems
> include unprintable characters appearing as the value of fields, and in one
> case, a portion of one field appeared under the column header of another
> field.  So in the latter case, not only did the order of the data not agree
> with the order of the headers, but the displaced column included only a
> portion of the value the original field.
> 
> These issues can be reproduced, and additional details can be provided if
> necessary.
> 
> It is my hope that these are some of the issues that are covered by the set
> of patches created by David Mansfield.  Any information on this will be
> appreciated.
> 
> What is the status of the patches?  Where can I obtain them?

Ask and ye shall receive!

David

-- 
/==============================\
| David Mansfield              |
| mdb...@db...       |
\==============================/

Re: [mdb-dev] mdb-export problems

[Marc D. <mar...@gm...>]

Hi!

I think you will be very interested to know that there are two critical
bugs in the current version of mdb-tools (0.5rc2).=20

I reported the first one in April and I received a patch from one of the
developers. (Thanks!) However, the patch has not been integrated in the
current version.

I tried compiling the cvs version, but it did not work.

In August I reported another serious bug. All integer numbers bigger
than 32 bit are converted to negatives. I reported the bug, nothing
happened (not one answer about the bug in this mailing list). Also I
tried to fix it myself, but failed.

I would very much appreciate your input.

Thanks,
Marc

--=20
 mailto:ma...@cr... | http://www.creative-sadness.de

[mdb-dev] mdb-export problems

[Lane S. <la...@cy...>]

For starters, mdb-tools has been very helpful to me.  I appreciate the
effort that has been devoted to create this suite of tools.

I have been experiencing some problems exporting tables.  The problems
include unprintable characters appearing as the value of fields, and in one
case, a portion of one field appeared under the column header of another
field.  So in the latter case, not only did the order of the data not agree
with the order of the headers, but the displaced column included only a
portion of the value the original field.

These issues can be reproduced, and additional details can be provided if
necessary.

It is my hope that these are some of the issues that are covered by the set
of patches created by David Mansfield.  Any information on this will be
appreciated.

What is the status of the patches?  Where can I obtain them?

Thanks,
Lane.
-- 
Lane Stevens
Terrapin Technologies, Inc.
http://www.cycletime.com

Re: [mdb-dev] inporting data to mysql

[txemi <tx...@eu...>]

> >
> See Migrating from Microsoft Access to MySQL at:
> http://www.kitebird.com/articles/access-migrate.html

This worked for me, thank you very much. Now I use a mysql backend from
ms access. Next step I will try to get a nice frontend to mysql data so
I can get rid of Windows machines; perhaps some php as it seems there is
not any nice front-end to make querys easely.

Thanks again,
txemi

-- 
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org

Re: [mdb-dev] inporting data to mysql

[Charles N W. <jac...@th...>]

txemi wrote:

>Hi, I am trying to export data from microsoft access to mysql.
>
>I am doing it exporting text data from Microsoft Access or mdbtools to
>text files and then inporting it with LOAD DATA from mysql. The problem
>is than I cannot find a combination of field deparator, escape secuence,
>etc... for not loosing data in the transfer.
>
>Could anybody provide a hint to do it in other way? Perhaps using odbc
>or something like that?
>
>  
>
See Migrating from Microsoft Access to MySQL at:
http://www.kitebird.com/articles/access-migrate.html

RE: [mdb-dev] inporting data to mysql

[Gary S. <ga...@pr...>]

That's the ticket...  We have used it to convert a bunch of departmental =
data into MySQL for a small business.  It took a little bit of playing =
time.  BTW, ensure that each MySQL table has a date/time fields called =
timestamp.  Just add it if it doesn't exist.  It will be useful because =
some versions of access are too stupid to determine if a record has =
changed or not (unless your name is SQL Server :) -- great marketing =
there).  Anyways, after you do the import you can easily drop the field.

Gary Smith

 -----Original Message-----
From: 	txemi [mailto:tx...@eu...]=20
Sent:	Saturday, September 06, 2003 5:47 PM
To:	Gary Smith
Cc:	mdb...@li...
Subject:	RE: [mdb-dev] inporting data to mysql


I found this mysql-odbc windows driver:

http://www.mysql.com/downloads/api-myodbc-3.51.html

I'm about to try it...

El dom, 07-09-2003 a las 01:13, Gary Smith escribi=F3:
> If you have access to the Win platform install the MySQL ODBC drive =
and just create a query.  I know this has nothing to do with MDB-DEV app =
but it's simple and fast.
>=20
> Gary Smith
>=20
> =20
>=20
>  -----Original Message-----
> From: 	txemi [mailto:tx...@eu...]=20
> Sent:	Saturday, September 06, 2003 3:24 PM
> To:	mdb...@li...
> Subject:	[mdb-dev] inporting data to mysql
>=20
>=20
> Hi, I am trying to export data from microsoft access to mysql.
>=20
> I am doing it exporting text data from Microsoft Access or mdbtools to
> text files and then inporting it with LOAD DATA from mysql. The =
problem
> is than I cannot find a combination of field deparator, escape =
secuence,
> etc... for not loosing data in the transfer.
>=20
> Could anybody provide a hint to do it in other way? Perhaps using odbc
> or something like that?
--=20
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org

RE: [mdb-dev] inporting data to mysql

[txemi <tx...@eu...>]

I found this mysql-odbc windows driver:

http://www.mysql.com/downloads/api-myodbc-3.51.html

I'm about to try it...

El dom, 07-09-2003 a las 01:13, Gary Smith escribi=F3:
> If you have access to the Win platform install the MySQL ODBC drive and j=
ust create a query.  I know this has nothing to do with MDB-DEV app but it'=
s simple and fast.
>=20
> Gary Smith
>=20
> =20
>=20
>  -----Original Message-----
> From: 	txemi [mailto:tx...@eu...]=20
> Sent:	Saturday, September 06, 2003 3:24 PM
> To:	mdb...@li...
> Subject:	[mdb-dev] inporting data to mysql
>=20
>=20
> Hi, I am trying to export data from microsoft access to mysql.
>=20
> I am doing it exporting text data from Microsoft Access or mdbtools to
> text files and then inporting it with LOAD DATA from mysql. The problem
> is than I cannot find a combination of field deparator, escape secuence,
> etc... for not loosing data in the transfer.
>=20
> Could anybody provide a hint to do it in other way? Perhaps using odbc
> or something like that?
--=20
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org

RE: [mdb-dev] inporting data to mysql

[txemi <tx...@eu...>]

Yeah, it does not use mdbtools, but I like it. I have not experience
with odbc, so I will ask you for a litle more help... Is this what you
tell me to do?

- I put the mdb file on a windows machine.
- I put the odbc driver on the linux/mysql machine. (should be
obcd-mysql driver be there or in the windows machine instead? Is odbc an
api or does it have a network protocol? should I find a mysql-odbc
windows driver?)
- I configure a odbc source in odbc.ini in linux machine.
- From windows y try to configure a odbc data source pointing to odbc
source on linux machine.
- From ms access I try to reach the newly odbc configured mysql
database.
- Now should be able to easely copy data from one database to other
using access.

Is this right or am I completely wrong? :-)

Thanks for your quick answer,
txemi.

El dom, 07-09-2003 a las 01:13, Gary Smith escribi=F3:
> If you have access to the Win platform install the MySQL ODBC drive and j=
ust create a query.  I know this has nothing to do with MDB-DEV app but it'=
s simple and fast.
>=20
> Gary Smith
>=20
> =20
>=20
>  -----Original Message-----
> From: 	txemi [mailto:tx...@eu...]=20
> Sent:	Saturday, September 06, 2003 3:24 PM
> To:	mdb...@li...
> Subject:	[mdb-dev] inporting data to mysql
>=20
>=20
> Hi, I am trying to export data from microsoft access to mysql.
>=20
> I am doing it exporting text data from Microsoft Access or mdbtools to
> text files and then inporting it with LOAD DATA from mysql. The problem
> is than I cannot find a combination of field deparator, escape secuence,
> etc... for not loosing data in the transfer.
>=20
> Could anybody provide a hint to do it in other way? Perhaps using odbc
> or something like that?
--=20
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org