Newsgroup: it.comp.appl.access
Titolo: Access to MySQL

è possibile esportare le tabelle di access nel formato MySQL?
se si come si fa?
Grazie!
ps premetto che non so nulla di MySQL

 se si come si fa?
con una apposita procedura freeware nota su internet con vari nomi di cui ti
riporto l'inizio
' exportSQL version 2.0
' 
www.cynergi.net/prod/exportsql/
'
' (C) 1997-98 CYNERGI - 
www.cynergi.net
, 
in...@cynergi.net
' (C) Pedro Freire - 
pedro....@cynergi.net
  (do not add to mailing lists
without permission)
'
' This code is provided free for anyone's use and is therefore without
guarantee or support.
' This does NOT mean CYNERGI delegates its copyright to anyone using it! You
may change the
' code in any way, as long as this notice remains on the code and CYNERGI is
notified (if you
' publish the changes: if your changes/corrections prove valuable and are
added to the code,
' you will be listed in a credit list on this file).
'
' MODULE
'   "exportSQL"
'
' GOAL
'   Export all tables in a MS-Access database file to 2 text files:
'   one containing SQL instructions to delete the new tables to be created,
'   and the other with SQL instructions to create and insert data into
'   the new tables. The table structure and data will resemble as much as
'   possible the current Access database.
'
' HOW TO USE
'   Copy-and-paste this text file into an Access module and run the first
'   (and only public) function. in more detail, you:
'   * Open the Access .mdb file you wish to export
'   * in the default database objects window, click on "Modules", and then
on "New"
'   * The code window that opens has some pre-written text (code). Delete
it.
'   * Copy-and-paste this entire file to the code module window
'   * You may hit the compile button (looks like 3 sheets of paper with an
arrow on
'     top of them, pressing down on them), or select Debug, Compile Loaded
Modules
'     from the top menu, just to make sure there are no errors, and that
this code
'     works on your Access version (it works on Access'97 and should work on
Access'95)
'   * Close the code module window - windows will prompt you to save the
code:
'     answer "Yes", and when promped for a name for the module, type
anything
'     (say, "MexportSQL")
'   The module is now part of your Access database. To run the export, you:
'   * Re-open the code module (by double-clicking on it, or clicking
"Design"
'     with it selected). Move the cursor to where the first "Function"
keyword appears.
'     Press F5 or select Run, Go/Continue from the top menu.
'   * Alternativelly, click on "Macros" on the database objects window,
'     and then on "New". On the macro window, select "RunCode" as the macro
action,
'     and "exportSQL" as the function name, bellow. Save the macro similarly
to the
'     module, and this time double-clicking on it, or clicking "Run" will
run the export.
'
' BEFORE RUNNING THE EXPORT
'   Before running the export, be sure to check out the Export Options just
bellow this
'   text, and change any according to your wishes and specs.
'
' TECH DATA
'   Public identifiers:
'   * Only one: "exportSQL", a function taking and returning no arguments.
It runs the export.
'   Functionallity:
'   * Can export to mSQL v1, mSQL v2 or MySQL-recognised SQL statements
'   * Excellent respect for name conversion, namespace verification, type
matching, etc.
'   * Detects default values "=Now()", "=Date()" and "=Time()" to create
types like "TIMESTAMP"
'   * Fully configurable via private constants on top of code
'   * Exports two files: one for erasures, another for creations (useful
when updating dbs)
'   * Generates compatibility warnings when necessary
'   * Code and generated files are paragraphed and easy to read
'   * Access text and memo fields can have any type of line termination:
\n\r, \r\n, \n or \r
'   * Properly escapes text and memo fields, besides all types of binary
fields
'   * Closes all open objects and files on error
'   * Known bugs / incomplete constructs are signalled with comments
starting with "!!!!"
'   * Two alternatives on absent date/time type on mSQL: REAL or CHAR field
ciao
B.

 > è possibile esportare le tabelle di access nel formato MySQL?

Grazie per l'aiuto, ho solo un piccolo problema:
cliccando sul link si apre un sito che non parla assolutamente di MySQL (fa
servizi internet, domini, ecc)
sai darmi altri link?
grazie

 ha scritto nel messaggio
news:EaZFa.82545$Ny5.2...@twister2.libero.it...

Se usi DbTool che puoi trovare linkato sul sito ufficiale di MySQL
hai la possibilità di importare nel tuo DB(MYSQL) direttamente
DATI eSTRUTTURA da ACCESS.
@Alex.