Add submit_time to all excel internet queries – too many columns for tiny url

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    No, you have to use “show”.

    But if you bough the editor and take a backup file from the import page, you will get the submit_time.

    Thread Starter awesam_s

    (@awesam_s)

    So there is NO way whatsoever to add the submit_time to the internet query.

    I’ve tried to show method but it has so many fields that it just doesn’t work well in excel as i have an access database which uses the information in the excel spreadsheet to import into the db.

    There must be a way – is it not possible whatsoever and how come?

    Many thanks for your time

    Plugin Author Michael Simpson

    (@msimpson)

    Come to think of it, you can put in show submit_time and a regular expression for everything else. Try:

    show="submit_time,/.*/"

    That should be short enough to fit in the IQY

    Thread Starter awesam_s

    (@awesam_s)

    Great thank you so much!

    This worked – for anyone else struggling with this.

    Open CFDB DB create a custom link copy to notepad and add this command like below show=submit_time,/.*/

    to the end. copy and paste in IE hit enter and save the iqy file then use it in excel by using existing connection and browse for more, use this file and enter u/p details and off you go enjoy!

    Thanks again Michael!!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Add submit_time to all excel internet queries – too many columns for tiny url’ is closed to new replies.