I've never heard of timeslips, but I assume that it is some sort of time/attendance package. Do you know anything about the database engine that it uses? Lots of the file based database engines use the .db extension, so that doesn't help much.

Does the Timeslips package have any kind of export module built into the package itself? Can that write to a file format that you can use?

-PatP

clariK

I also am trying to extract fields from timeslips (2008), would you detail how you were able to do this

I first went into Access 2000 and when creating a table chose link table. I found the timeslips database (.db) that had the information I needed. I then created a new table to hold the fields from the timeslips database that I wanted. I created a query to add the data to the new table from the link table. This seemed to work however I developed some locking issues. I realized that I could just import the tables from timeslips when I needed to update the table. In my case that is once a month. I still use queries to populate the new table. To import the table just click new table, browse out to where the timeslips .db's are. Change the file type so you can see the db's. Then just select and import.

http://www.timeslips.com/

don't mention what underlying database is used. .db may indicate that it's a dbase/foxpro/clipper database (although .db is a common custom extension as well.)

IF they're dbase/foxpro/clipper, then you should be able to use ODBC to connect from Access, & import the tables.

If it's a custom flat file format, you should still be able to connect to it for import; either as a fixed-width format or a character separated format. You'll just need to open the .db file in a hex editor (or even with notepad) to determine the format. Once you've nailed down the format, then you could define an import approach