Ask Your Question

I can amend my table

asked 2020-05-23 18:16:44 +0200

Paulus17 gravatar image

Ive linked to a spreadsheet to bring in data but i can't seem to amend the Table - e.g. to make a field an index

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-05-23 19:28:02 +0200

keme gravatar image

updated 2020-05-25 00:04:26 +0200

A database which holds data in a spreadsheet file is a pseudo database. You can use it as a data source, but for anything beyond basic data extract you should import the data into a proper database solution.

The embedded db engines are better in this respect, but still limited in some ways. For single user/single access instance either should do fine. If you need the latest functionality, multiple concurrent access or better performance, install either of them, or any other DB server software, as a standalone DB server.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-05-23 18:16:44 +0200

Seen: 32 times

Last updated: 2 days ago