0

Connect to an existing Database (Text), what DB is it?

asked 2020-12-17 10:30:38 +0100

Phrance QueTara
1 ●6 ●7

When creating a new database via Menu | File | New | Database ==> (*)Connect to an existing Database [Text], (basically, to link to an entire folder full of CSV data files), will the default underlying embedded database be an HSQLDB, Firebird, or neither? If it's neither, what would it possibly be?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

0

answered 2020-12-17 18:15:19 +0100

Ratslinger
26471 ●9 ●35 ●135

updated 2020-12-18 02:04:46 +0100

Hello,

In connecting to a text file or spreadsheet and such, there is no underlying database. It is simply a link to the existing data.

Edit:

This may also be of interest to you -> [Base] Linked Table from CSV. See link in accepted answer.

edit flag offensive delete link

Comments

I see. That's probably why the resulting tables not relational, and therefore cannot queried via SQL statements. Correct?

Phrance QueTara ( 2020-12-18 00:13:42 +0100 )edit

@Phrance QueTara,

You can do very simple single table SQL such as:

Select * from TABLE Where ID = '1'

Ratslinger ( 2020-12-18 01:04:55 +0100 )edit

Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-12-17 10:30:38 +0100

Seen: 31 times

Last updated: Dec 18 '20

Related questions

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Powered by Askbot version 0.9.3