Ask Your Question
0

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

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

Phrance QueTara gravatar image

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 gravatar image

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 more

Comments

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

Phrance QueTara gravatar imagePhrance 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 gravatar imageRatslinger ( 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