FirstLoveMovies

Pretty cool. That database you used, can it be converted to MS Access 2003 ??

Access can import .CSV's. Not sure about .XL's.

Phuzzy4242 wrote:Access can import .CSV's. Not sure about .XL's.

You can, but if you want even more control you can export the Excel data to CSV and then import it in Access.
https://support.microsoft.com/en-us/off ... 84913cc958

GrumpySneezy wrote:Pretty cool. That database you used, can it be converted to MS Access 2003 ??

I'm not really familiar with Access, but I'm sure you will be able to find some tools to convert between the formats if you search online for something like "convert sqlite to access format". Or you could try converting the SQLite to an intermediary format such as CSV, and then importing the CSV into Access or Excel.

emuler wrote:

Phuzzy4242 wrote:Access can import .CSV's. Not sure about .XL's.

You can, but if you want even more control you can export the Excel data to CSV and then import it in Access.
https://support.microsoft.com/en-us/off ... 84913cc958

That's what I said. You can manipulate how a CSV is imported and even assign key fields while doing it. I haven't used MSAccess in years but I remember a few things about it.

emuler wrote: but such a disorganised mess I can't find stuff for shit. I find myself downloading stuff that I already have.

of course, that would NEVER EVER happen to mé!!!! never never ever ever .....
Nuh-uh.....