| data migration [message #74290] |
Thu, 28 October 2004 12:42 |
azam
Messages: 5
Registered: August 2004
|
Junior Member |
|
|
actually i need following script
So, basically, the script will have to do the following:
1) Look in a particular directory that contains all of the .ncs files
2) Loop through files
a) Change filetype to .mdb
b) Connect to the file via ODBC and query the appropriate data
c) Connect to MNUSS(database) via ODBC
d) Query the MNUSS data to determine if the records already exist (decide if next query is an insert or an update)
e) Execute insert or update queries on relevant MNUSS tables
The script should create a log file of all actions so that they can be verified
please reply me soon
thanks
muhammad azam
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
