I've seen lots of traffic about connecting to Access data files with OpenOffice Base. I don't necessarily want to connect to an .MDB, but I would like to import a large amount of data from an Access db into OO-Base and then use the data in native OO-2.1 format. In fact to get the data into Access I actually import it from a database at work that runs under Pentamation (I don't know what format is native to that system). I can get the data from the source in either delimited text or Excel format, so I could import the same data directly from either of those without even going through Access, but I can't find a way to import the data into a Base table.
The point of doing this is to be able to use the same data file across machines using both Windows XP and Linux. I know I can connect directly to the .MDB on the Windows side, but I want to use the same data in Linux OO. It seems like there ought to be a direct way to import data into a new table in Base, but I can't find it (it ends up as spreadsheet data or a word processing table whenever I try). Thanks in advance for any help. Karl Krelove
