access denied when using load data infile

2004-04-17 Thread Jan Broermann
Hi, I've got a little Excel Macro that connects to MySQL via ADO below is the code. Funny thing is it connects to the database and executes the truncate orders without a problem. But when I come to Load data in file i receive an [MySQl][ODBC 3.5.1 Driver][mysql-4.0.18-nt]Access denied for user :'[

Missing an answer to an topic (Finding gaps in db)

2002-09-09 Thread Jan Broermann
Hi, I'm missing an answer to a topic which came up a couple of days /weeks ago. For a database i'm administrating I would like to find out, which numbers (of invoices) are missing in our database. Is there a way to get this result set thru SQL? Or do I have to do it with for example Java? I think

Missing an answer to an topic (Finding gaps in db)

2002-09-09 Thread Jan Broermann
Hi, I'm missing an answer to a topic which came up a couple of days /weeks ago. For a database i'm administrating I would like to find out, which numbers (of invoices) are missing in our database. Is there a way to get this result set thru SQL? Or do I have to do it with for example Java? I think

Missing an answer to an topic (Finding gaps in db)

2002-09-09 Thread Jan Broermann
Hi, I'm missing an answer to a topic which came up a couple of days /weeks ago. For a database i'm administrating I would like to find out, which numbers (of invoices) are missing in our database. Is there a way to get this result set thru SQL? Or do I have to do it with for example Java? I think