If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Other PC Databases > Timeslips DB files

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-08-07, 17:11
koconnor koconnor is offline
Registered User
 
Join Date: Jan 2007
Posts: 1
Timeslips DB files

Has anyone found a way to access these using MS Access? I have a client using Timeslips 2006 and they want to get out of it their slips and invoice data. the extension is .db but it does not work using he Paradox ODBC in Access, I have tried Access 95, 97, 2000, 2K2 and 2003 none work - Kevin
Reply With Quote
  #2 (permalink)  
Old 01-10-07, 07:43
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,612
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
Reply With Quote
  #3 (permalink)  
Old 01-25-07, 16:11
clariK clariK is offline
Registered User
 
Join Date: Dec 2006
Posts: 7
You should be able to create a link table in Access. I was able to do this. You might need to use a query to populate a new table. Otherwise you might have locking issues in timeslips.
Reply With Quote
  #4 (permalink)  
Old 10-04-07, 12:15
jboote jboote is offline
Registered User
 
Join Date: Oct 2007
Posts: 1
clariK

I also am trying to extract fields from timeslips (2008), would you detail how you were able to do this
Reply With Quote
  #5 (permalink)  
Old 10-08-07, 12:04
clariK clariK is offline
Registered User
 
Join Date: Dec 2006
Posts: 7
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.
Reply With Quote
  #6 (permalink)  
Old 10-09-07, 13:41
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,797
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
__________________
Lou
使大吃一惊
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Last edited by loquin; 10-09-07 at 13:45.
Reply With Quote
  #7 (permalink)  
Old 03-20-09, 02:12
shafat shafat is offline
Registered User
 
Join Date: Mar 2009
Posts: 1
You may want to download BillQuick. It converts Timeslips DB to Access.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On