MySQL Forums
Forum List  »  Microsoft Access

Re: Import data from an excel spreadsheet into an mysql database
Posted by: Jay Alverson
Date: April 09, 2009 08:03AM

Quote

Matthew Adams Wrote:
-------------------------------------------------------
> You should try using DAO.DBEngine.36 , it's so
> much faster than ADODB and not depricated
> (ADO/ADOX was created for access 2k and 2k2, but
> then dropped again for updated DAO (The old
> library) for 2k3 and 2k7 (It took 13 hours to
> process with ADOX all the tables in a database in
> access 2k format with 49 tables and a few hundred
> queries, and 2(+-1) minutes with DAO to do the
> same (on a 1.2ghz celeron :|..))

Thanks for the info Matthew. I can't say I've done extensive testing.

Have you any sample code you can share ?

I've done work with Access.Application and DAO(3.5 and 3.6) but generally
for small projects.

I don't believe I use ADOX, just ADOdb. I think I've used the catalog
of ADOX a few times.

I really like importing from MySQL into Excel using .QueryTable object
and a fileDSN. Boy that's easy. Linking to MySQL tables in Access is
also simple.

I've also used .DoCMD and the menus to copy a table straight from Access into
MySQL.

>

Thanks, Jay

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Import data from an excel spreadsheet into an mysql database
7151
April 09, 2009 08:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.