I'm using Automate5 to perform a SQL query on an excel file. This works fine except when the header row of the excel file contains characters such as ? . ( ) etc
Is there any way to write the SQL SELECT such that it refers just to col1, col2 etc, or to bypass the first row of the file?
Peter
Ok - I'm confused.
On my desktop (XP Home and Office 2000), I use Outlook2000 and my wife uses Outlook Express. What I want is for both programs to use (read, update, delete) the same set of names and addresses so that we share a common address book.
I know this is possible because it is how...
One of my clients has started to run one of my huge Access V2 applications under Windows XP (previously 95 and 98). We are now getting some date handling issues (e.g. invalid syntax errors) that we used to get in Windows 98, because the Control Panel/Regional Settings did not match what...
I am getting a problem where my networked Access 2.0 databases are becoming corrupt and unrecoverable. The strange thing is that their file size grows from 10 megabytes to 1 gigabyte plus!
This occurs with the server database which holds the data. Client side databases with the code are also...
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.