![]() ![]() JDBC drivers are cross-platform, though I’m not sure why that should matter to anyone but developers. What’s the difference between ODBC and JDBC drivers? There are some differences in speed and functionality. In Debian (and the *buntu family and Mepis and all of its many offspring) you need the unixodbc package for ODBC support, plus the driver specific to your database:Īnother option for PostgreSQL is the -sdbc-postgresql package, which replaces both the ODBC and JDBC drivers.įedora has different package names, and it does not include as many as Debian:Īny drivers that you can’t find in your distribution can be downloaded from (see Resources), or from the vendor of your database. You need special drivers to connect to a MySQL or PostgreSQL database, or any other external database. You can use a comma, single space, tab, colon, or a semi-colon for the delimiter. Any empty fields need “” for a placeholder, and each field is separated by a comma. You have to have the exact same number of fields in your field definitions line, which is the first line in the file, and in your data lines. "Schroder","Carla","Ms.","","","5678 EndOfTheLineLane",Įven though there are line breaks for readability, the real line breaks are at the ends of the lines with no commas. "Home Address State","Home Address Zip Code" "Home Fax","Home Address Street","Home Address City", Here is an abbreviated example from my KDE address book export: "Family Name","Given Name","Honorific Prefixes","Home Phone", csv file Base will have no problems with it. The next screen asks for the path, be sure to check “‘Comma separated value files ‘ (*.csv)”, and then select the correct delimiters. Then in the “Connect to an existing database” dropdown list, choose “Text”. If Base doesn’t have an option to directly import from your address book, try exporting your addresses into a comma-delimited. Double-click on the Address Book table to see your imported data Click finish, name and save the new file.Yes, register the database for me and open the database for editing.Importing this into Base is so easy your cat can do it: You can import their data into Base, but whenever you make a change to the source document you have to import the new data you can’t change it or directly access it from Base. Address books, spreadsheets, and delimited text files are read-only. So it also functions as a graphical front-end to other databases, and you can use it to edit and change them. Yours may have some different options, depending on your Linux distribution.īase can connect directly to most relational databases, such as MySQL, PostgreSQL, Oracle, Adabas D, or any database that supports the Open Database Connectivity (ODBC) or Java database connectivity (JDBC) drivers. But the good news is Base can import data from most other databases, spreadsheets, text-delimited files, and email address books. Your contacts list must be in Base, which is a bit of a pain. The steps for setting up any mail-merge document in OpenOffice are easy the one potentially gnarly bit is creating your contacts database in the first place. Last week we learned how to make pages of labels, business cards, and form letters using OpenOffice Writer and Base. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |