access info to other db via odbc 1

[camaropilot]

This must be simple and I am overlooking something. I have an access database timesheet and I want to export the info into Timberline payroll. Timberline is odbc compliant. Can anyone tell me specifically how to do this.

 

[tlbroadbent]

Timberline must have an ODBC driver. You need to install that if you haven't already. Create a DSN using the Timberline ODBC driver. Link the Timberline database tables (or files) to your Access database. You should be able to update those linked tables just as you would any table. That is, you can insert or append the records you want.

This is perhaps the easiest way to do what you want as long as Timberline is truly ODBC compliant. There may be other alternatives but not knowing Timberline, I can't say if anything else would work. Terry

http://members.home.net/tlbroadbent/index.htm

 

[camaropilot]

Excellent, very clear and informative. That is exactly what I needed to know. I know Timberline has an ODBC driver. I just needed to know which direction and what to link to where.

Thanks!