June 30, 2008 at 12:24 pm
I have to do some reporting on an Access database that keeps records of my company's phone system usage. This is typical call accounting stuff: call date, call time, call duration, Inbound/Outbound/Transfer, etc. All oft his information, and more, is stored in a single fixed-length string field. To make reporting easier, I'd am importing the data into a SQL database, using Substring functions.
I'd like to automate this as much as possible. Can I use DTS to automate the import and transformation? If so, can I get some guidance on how to set it up? I haven't done much with DTS, and none using an Access connection.
Thanks for any help. I can provide more specifics if needed.
June 30, 2008 at 12:47 pm
You can use DTS to do this, however you might want to import into a staging table, then update/insert into your regular tables.
You an also just link the Access tables to SQL Server and keep your application.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply