| Author |
 Topic  |
|
|
seahorse
Senior Member
USA
1075 Posts |
 Posted - 28 April 2004 : 03:50:24
|
Hi All,
Does anyone know if you can export Access tables and data as an SQL file? I've looked and can't quite seem to find it.
Thanks. |
Ken
===============
Worldwide Partner Group
Microsoft |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 28 April 2004 : 09:35:04
|
| Only way I can think of is importing into SQL server or MSDE and then exporting from there. |
Erick
Snowmobile Fanatics
|
 |
|
|
seahorse
Senior Member
USA
1075 Posts |
Posted - 29 April 2004 : 08:03:08
|
quote:
Originally posted by ruirib
Not that I know of. Can I ask why you want that?
I'd like to export an Access DB to MySQL
I'd usually use AccessDump, but I've been having problems with it lately. |
Ken
===============
Worldwide Partner Group
Microsoft |
|
|
|
chumbawumba
Junior Member
United Kingdom
304 Posts |
Posted - 29 April 2004 : 08:17:55
|
| MySqlFront v2.5 can *import* an Access DB directly. |
Can't stop, lose job, mind gone, silicon. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 29 April 2004 : 10:20:35
|
| So can SQLYog iirc. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 29 April 2004 : 18:42:12
|
I have often thought this was a feature that should be in access.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
seahorse
Senior Member
USA
1075 Posts |
Posted - 30 April 2004 : 08:52:42
|
It maybe cynical of me but I think they leave it out so that you stick with an MS product.
Thanks for the suggestions folks, I've downloaded MySQLFront. That looks promising. |
Ken
===============
Worldwide Partner Group
Microsoft |
|
|
|
chumbawumba
Junior Member
United Kingdom
304 Posts |
Posted - 30 April 2004 : 10:07:40
|
You must use v2.5, because the import facility was removed from v3.0
good luck |
Can't stop, lose job, mind gone, silicon. |
|
|
| |
Topic |
|
Topic Locked
