Search found 4 matches

by widget
Tue Feb 22, 2011 12:12 am
Forum: General Discussion
Topic: Append data to existing table in Access
Replies: 6
Views: 17432

Append data to existing table in Access

For the purpose of anyone following this thread, the two things that were needed here were; 1. Routine to ignore the first line in the txt database (which were the headers, and as such were reading in characters instead of numbers in the number fields of table) 2. Ensure my tabbed file was the prope...
by widget
Fri Feb 11, 2011 6:59 am
Forum: General Discussion
Topic: Append data to existing table in Access
Replies: 6
Views: 17432

Append data to existing table in Access

Is anyone able to help with the above? I'm struggling to find a solution to the data type mismatch which could mean I'm unable to justify purchasing the full version of Robotask, as it's looking like it won't be able to achieve the goals of my automation which would be a real sham... unless anyone c...
by widget
Tue Feb 08, 2011 8:01 am
Forum: General Discussion
Topic: Append data to existing table in Access
Replies: 6
Views: 17432

Append data to existing table in Access

Thanks very much for the above. This got me 90% of the way there, but, I'm experiencing a final error which is preventing me from successfully completing the automation. Firstly, to be clear, I should say that to get the above working I found I had to wrap the expression {CurrentLine(0)} in quotes, ...
by widget
Mon Feb 07, 2011 5:00 am
Forum: General Discussion
Topic: Append data to existing table in Access
Replies: 6
Views: 17432

Append data to existing table in Access

Hi, I'm evaluating RoboTask to see if can achieve the following task for our small business. 1. Log onto FTP server daily, and download the latest version of a tab delimited .txt file to our local File Server. (I've got this part working fine in RoboTask). 2. Upon detection of the new file being dow...