On Thu, 11 Sep 2008 11:11:13 -0500 Barbara Duprey <[EMAIL PROTECTED]> dijo:
> John Jason Jordan wrote: > <snip> > > I discovered that OOo Base cannot read or import Access databases. > > However, I also discovered that Kexi can do so. Kexi uses SQLite as its > > database engine. I successfully got my tables into Kexi, although the > > queries, forms and such failed to transfer. I didn't have many queries > > and forms so that didn't bother me - I figured I'd just recreate them. > > But the best part is that OOo Base was able to connect to the Kexi data. > > > > I don't remember the full discussion about why you used Kexi as an > intermediate, but in general, you can connect the tables from an Access > file directly into Base. If you want to bring them all the way into > Base, you can do a copy/paste into a Base (HSQLdb) table; this is likely > to lead to a faster and more stable environment. As mentioned elsewhere > in this thread, only tables can be used or copied from the Access > database, the other components have to be recreated in their Base > analogs to the Access queries, forms, and reports. Some things, like > update queries, require use of SQL commands. At the time I did it only Base running on Windows could read Access files. That feature was not available on Linux. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]