Re: EXPORTING DATA: OK, this might be a bit general but..

2001-06-19 Thread Erik Gillespie
I'm by no means an authority on this kind of stuff but you could write a portable C program that generates a big ol' SQL script containing INSERT INTO statements :) I can't really think of a fast way to do it since you want to go between MySQL and Access without ODBC and other utilities (I'm not

EXPORTING DATA: OK, this might be a bit general but..

2001-06-19 Thread David Ayliffe
I need some advice on how to export a tables data to import later into Access. This export HAS to be automated (and I'm using VC++ API for MySQL) The problems I'm faced with are (1) Before I can import this data into access I have to create the table in access; I'm familiar with ADO and creatin