ADO

[Kathy]

I used ADO to write to Excel spreadsheets,

Sometimes, at the statement :

rs.Update

---ERROR comes up :

[Microsoft][ODBC Excel Driver]Selected collating sequence
not supported by the Operating System


Anyone knows what the message means ?

Thanks

[PedroD]

I've seen this message when writing database applications using ADO with C++. The problem is that an exception (run-time error?) occurred whenever I used the back & forth buttons too rapidly.

I can't remember the exact name of the exception that occurred, but I'm pretty sure that if you handle any errors when doing a rs.MoveNext or similar, you'll find that your application does trap the errors, and that they're easy to deal with.

In most cases, just ignoring the error and resuming is enough.

P.Dias
Oslo, Norway

[Kathy]

Hi,
I really appreciate your answer.
I tried some Error handler, and it does trap the error.

Doing a resume next,and
it ends up writing 2 similar records into my file instead of 1
after that error

Any idea what else should I do?

Thanks

Try
On error goto ErrHandler

exit sub
ErrHandler:
' here you do something with the error or just ignore