Re: Importing tables into Kexi

[Swarup]

On 8/6/20 12:54 PM, Jaroslaw Staniek wrote:

Hi Swarup

KEXI can import individual tables from CSV at the moment. 

If that is the case then why is the .csv file I browse to greyed out in the import window. The import function is not permitting me to select the file of type .csv for import.

Also I wanted to point out that the CSV format:

- does not define representation of multiple tables

- does not define constraints like the permitted characters 

This is all application defined. MDB defines it so it could be useful for the import.

On Thu, 6 Aug 2020 at 17:14, Swarup <dinban...@sprynet.com> wrote:

Hi there,
So I have installed KDE Neon on my system using VM Ware, and by installing kexi there found that the export function worked and I was able to export my table from kexi, as a file of .csv format, which is perfect.

I would like to now important that .csv table back into kexi, this time adding more columns and increasing the number of permitted characters per cell. So I brought the .csv file over to my Ubuntu OS, and in Ubuntu I opened Kexi and opened the import function. However when I browse to the folder where the .csv file is located, everything is grayed out including the .csv file. Can Kexi import tables of type .csv, or does the file have to be of type .mdb?

Thanks,
Swarup