You can try to get Access to export as SQL script and then use H2 to import the SQL script. The problem is that Access might use certain SQL statements that H2 would not recognize.
Another way is to export as a CSV from Access and import into H2 as a CSV which is universally recognized format. On Nov 28, 4:56 am, justaguy <[email protected]> wrote: > Hi, > > The Access db has 10 tables but some of which has 20+ fields, creating > table one by one by someone like me who's new to H2 would be very > tedious and time-consuming, I wonder if there's a tool for it. > > Thanks. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
