Anybody can give me idea how this works?
First here are my resouces but yet limited.
ms access 2003
excel 2003
ms sql 2005
.rpt file or csv file for me to do upload.
Here's my goals.
1. to make automated ftp connection to fetch the files to the server.
2. after saving the file a code that will run on a batch file or job to do the data loading to my ms sql server.
I know I dont have a code yet to share but here's the point where I need start is to make idea or plan how will I do this. Thanks!
First here are my resouces but yet limited.
ms access 2003
excel 2003
ms sql 2005
.rpt file or csv file for me to do upload.
Here's my goals.
1. to make automated ftp connection to fetch the files to the server.
2. after saving the file a code that will run on a batch file or job to do the data loading to my ms sql server.
I know I dont have a code yet to share but here's the point where I need start is to make idea or plan how will I do this. Thanks!
Comment