Connect to an unknown file format?

[lcorcoran]

I've got a bunch of .pspc files from AutoCAD Plant3D. I can open them in “SQLite Expert Personal 5 - 64bit” and see a list of tables, but I specifically need data from the “EngineeringItems” table in each spec file.

I'm attempting to use Power Query to link to a folder containing these files, but when I try to expand the binaries, it doesn't recognize the .pspc format. I've tried searching ChatGPT and YouTube for solutions, but I'm just getting more confused. Do anyone happen to know any magical way to connect to an unknown file format?

 

[bobsan42]

if its an sqlite file then this should help:
Connecting Excel to SQLite via ODBC Driver
So you will need an ODBC driver

 

[lcorcoran]

if its an sqlite file then this should help:
Connecting Excel to SQLite via ODBC Driver
So you will need an ODBC driver

Thanks, it looks like I don't have the right ODBC Driver, I must of had more IT right in my last job as I was able to di alot more there, this company has more locked down system and I can't insall anything