Extracting data from MySQL into Access

2007-01-15 Thread Dewald Troskie
Hi, I know this is a weird request, but I need a tool / tutorial on extracting data from InnoDB tables in MySQL 5.x and putting the data into Microsoft Access. COuld anybody advise me where to do this? Thanks, Dewald Troskie

RE: 1' and '1' or '1

2006-05-10 Thread Dewald Troskie
as the provider. Using the login credentials you supplied, The site rejects it as you have to have explicit username and password (which is encrypted on creation in the DB) details to login. HTH, Dewald Troskie GIS Developer / Database Architect GIS Global Image (Pty) Ltd. Helping the world make informed

RE: comparing postgis with mysql

2006-05-10 Thread Dewald Troskie
on these two DB's and mail them to you. Thanks, Dewald Troskie GIS Developer / Database Architect GIS Global Image (Pty) Ltd. Helping the world make informed decisions P.O Box 15 The Innovation Hub 0087 Cell: +27 (0)72 685 4246 Tel: +27 (0)12 844 0660 Fax: +27 (0)86 619 3958 Email: [EMAIL

Table parameters not transferring while using Migration toolkit

2006-02-22 Thread Dewald Troskie
fields with default values all of a sudden show as NOT NULL. I'm using MySQL Server 5.0.11 and Migration Toolkit 1.0.21rc. Any suggestions / ideas as to why this is happening (the transfer is done online, so all objects and data is moved online and not scripted). Thanks, Dewald Troskie GIS

Data type in MySQL / ASP.net

2005-11-29 Thread Dewald Troskie
Hi, I'm relatively new to the MySQL / Web development - database environmeent, having moved from Microsoft SQL. Just two questions ? 1. I have an ASP.Net page that commits data to a MySQL database. I have several check boxes on the page. What data type do I define my fields in the database as