Connection to csv, txt and xlsx

[PedroReus]

Dear

Along with saying hello, I present the following query, I try to import a file in csv or text or xlsx format, but I don't know where I should connect and how the connection is managed in relation to the configuration

[LonwoLonwo]

Hello @PedroReus

If I understand you correctly, do you have the file with some data? What kind of data it is? Any database-specific fields (like timestamp with timezone)? Maybe you know, what database was used when creating this file?

[PedroReus]

Hello, I actually have files in csv, txt and xlsx format which I need to import in order to join. The data I have is of type number, text and dates.
Therefore I need to know how to connect and configure the import of these files to DBeaver correctly.
It would be helpful if you can show me the step by step or coordinate a video call to know what I should do

[LonwoLonwo]

Ok. We have much helpful info in our Wiki: https://github.com/dbeaver/dbeaver/wiki

You can read about the new connection here: https://github.com/dbeaver/dbeaver/wiki/Create-Connection
About data import here: https://github.com/dbeaver/dbeaver/wiki/Data-transfer#importing-data-from-csv-format

Also, you can add the folder with your CSV (only CSV) files as a separate connection.

With CSV driver you can open SQL Editor and create SELECT queries with JOINs: https://github.com/dbeaver/dbeaver/wiki/SQL-Editor
But you can't change data, just read.

[PedroReus]

I've been looking at what you wrote me yet I can't connect to a csv or txt file.
What I do is the following

1. I select the connector
   
2. I get the following configuration, I understand that I must look for the path of the files in csv format
   
3. I look for the path of my files and finish the task
   
4. This appears as a connector
   
5. I get this error
   

I understand that I have to configure some drivers but I don't know what it is or if I'm doing something wrong

[LonwoLonwo]

Maybe you have some connection restriction for DBeaver, I don't know.

You can add download and add driver manually in the Connection Settings -> Edit Driver Settings -> Libraries -> Add File/Download

But I see that you have many Oracle connections.
You can import your files into the new tables.

[PedroReus]

I was able to connect with the csv format. (Thanks for the support).

Now I don't know if DBeader can do the same for files (tables) in xlsx or txt format?

[LonwoLonwo]

Now I don't know if DBeader can do the same for files (tables) in xlsx or txt format?

DBeaver can not open XLSX or txt files as tables. Only CSV.

Also, the ability to use import from XLSX file you can use only in DBeaver commercial version.

[p91paul]

@PedroReus for txt, it depends on the content. If the txt is actually similar to a csv (fields delimited by something) the csv connection lets you specify delimiter and extension.

[PedroReus]

@p91paul Perfect, and in relation to the excel (xlsx) format, could the csv connection be used?

[p91paul]

I think for xlsx what @LonwoLonwo said applies. You cannot open them as tables but you can import them on the enterprise version. The csv driver only supports delimited text files.

[TiViAx]

I'm giving you the answer late, but you can save the xlsx file in csv format, although each individual sheet must be saved to a separate csv file. This way you will get a database of n-files. Next, we do all of the above.