Looking for some advice. I have a customer who needs to upload data from iMIS to a 3rd party custom database.
I have initially created the extracts for testing purposes in MSAccess. So here are my questions.
1 -- has anyone automated uploading TXT files through FTP and having the file name to include todays date.
2 - Can it be done from MSAccess or does it have to be rewritten in SQL?