Custom data source in Base as table

Hi, this is my first question here:

I have a MySQL database that have some tables and need to add a custom table that have data from file system, like path, file name, extesion, file size, creation date, etc… Well, final destination of that information in Calc, don’t know if possible too. How to achieve that? My background is Java, php, SQL, Javascript but never coded with Basic and Macros, is not a problem for me to learn languages, but first I want to know if is possible to create a “table” with such information, in any way.

Thanks in advance :slight_smile:

Yes it is possible but will take extensive work on your part. Start with getting Open Office Macros Explained . Chapter 8 deals with File routines. Once you build your table make sure your Base file is registered and then you can use it in Calc.