Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    113

    Unanswered: sql query automation to ftp site

    Hey guys,
    i need some help and I am not an experienced .net programmer. This is the current situation. I am using a toolkit viz excel which allows me to login and connect to a server using macros. The toolkit contains a textbox where I can type in a SOSQL(own sql language who created the toolkit). I am Able to query the 9 tables I desire but I need to be able to automate this process nightly. How do I go about doing this? All the collumns also need to be set as type general unless it is a date or a number. Is there anyway I can do this through access? I have attached a txt file with the vbcode. Please help. tHANK you so much
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2004
    Posts
    113
    another thing is that, once the queries are automated I wanted to automate uploading them to an ftp site. Thanks guys.

  3. #3
    Join Date
    Sep 2004
    Posts
    113
    bump.............................................. ...........................

  4. #4
    Join Date
    Sep 2004
    Posts
    113
    bump............................................

  5. #5
    Join Date
    Sep 2004
    Posts
    113
    bump.............................................. .................

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •