Hi, I am working in access 97 and am wanting to use a file select dialouge box with the ability to mutiselect files from any directory. I need to understand how to break the File String up. E.G The code runs a loop I need it to insert the last directory within a string and the filename...
Hi I have some code already that takes a list of file names and imports the data from Excel to Access using range names. The code is below.. The code looks at the filenames and transfers data into tables then inserts the names into various tables using SQL insert. What I would like is for the...
I am trying to build an Excel front end package that will pull data from access. This is fairly easy when I am pulling the data from tables and some queries. The problem I get is when I try to extract from a query that has "from_date/to_date" it blows out. Is there any way to get...
Hi, Im looking for a program that can read a 7 digit number from a text file into a session screen and retrieve sections of data on the screen and save into a txt file, looping until the eof of 7 digit txt file.
At present can do this easily with dyna comm scripts but strugle with Attatchmate...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.