Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Create a new dbase (dbf) table (Read 3450 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Create a new dbase (dbf) table
18.02.10 at 09:57:16
Create a new dbase (dbf) table
It is very easy to create a new dbase table using SQL*XL. You do not need any other dbase software for this!
Just use the SQL*XL connection wizard and connect to a directory as a dbase database. This can be any directory. If you want to keep your disk clean, create a new directory and connect to that. I am using c:\dbf_test.
To create a table just run a create table statement from the SQL dialog in Excel. For example:
create table d (id number, data_d varchar(20))
You can also use SQL*XL's multiple rows insert feature to create the table and insert data.
This is a very easy and elegant way to quickly dump spreadsheet data into a table to be able to access it through SQL.
Back to top
« Last Edit: 18.02.10 at 10:00:49 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1