Ask Your Question
0

Being able to import spreadsheets to a database and arranging the date.

asked 2018-01-03 11:12:23 +0200

ERas gravatar image

I've got a folder of a bunch of invoices that need to be sorted by date. They don't have the dates written on the filename but they do have a date on a specific cell in the spreadsheet. So I need to import the spreadsheets in the database, pick the cell that has the date, arrange it accordingly, and see what spreadsheets are within the desired date range.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-01-05 02:24:41 +0200

Ratslinger gravatar image

Hello,

I don't believe there is an easy solution for your request. Calc data can be inputted in Base tables in two ways: linked and csv.

When linked, Base gets whatever decipherable data from the sheets in the document and creates tables based upon this. This data is rows and columns of the same type information. The same is true of creating csv files from the sheets. Now based upon provided information it doesn't appear you sheets would be arranged as such. Since they are invoices you probably have a section for name & address another section for details & yet another for totals. This would not be a format understood in simple conversion.

Unless what you have is significantly different than described, then the only solutions to get this information into a database would be custom programming to read the sheet data and transcribe it into a format acceptable for entry into table(s) or manually copy data item by item.

It may be easiest to just rename the files to include the date.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-03 11:12:23 +0200

Seen: 154 times

Last updated: Jan 05 '18