Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-23 : 08:00:47
|
| Gus writes "I have (2) Excel spreadsheets that contain many sheets and many columns of data. Our employees update these spreadsheets everytime they have to deploy our software to a client. This means they add data, remove data, etc. They currently copy and paste this data into the appropiate tables in access. This enables our program to work. We are moving to SQL 2000 backend and need a way to poplulate these tables automatically. I would like to use a tool such as data import to do this. Please provlde me recomendations. This package has to be very user friendly. Due to the people using it may have no or limited excel or SQL 2000 experience.Thank You." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Excel 