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

    Unanswered: SQL query automation through excel/VB

    Hey guys,
    i need some help and I am not an experienced vb programmer. This is the current situation. I am using a toolkit via 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 in a text box but I need to be able to automate this process nightly. How do I go about doing this? All the columns 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 really need help on writing the code itself. I have attached a txt file with the vbcode along with a screenshot of the interface Please help. tHANK you so much
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2004
    Posts
    113
    when i mean automate, these queried 9 tables need to be uploaded unto to a ftp site. Please help. Im in a standstill

Posting Permissions

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