Problem with VBA/ADO Select Into

[JohnM3]

When I run this routine - I get
Unexpected error from external database driver (1309)

Not certain if (a) I can do Select into (b) my sql syntax is wrong or (c) I have
left something out ....

Here is code ....

Please Login or Register  to view this content.

Thanks for any help with this.

regards
JohnM3

[snb]

Try:

Please Login or Register  to view this content.

[romperstomper]

You can't do a SELECT INTO with an open workbook (you shouldn't really use ADO with open workbooks anyway due to memory leaks). If you have an existing sheet with the right headers, you can use an INSERT INTO, or you can use the SELECT INTO if the workbook is closed.

[JohnM3]

Hi snb

Please Login or Register  to view this content.

regards
JohnM3

[JohnM3]

Hi romperstomper ...

You can't do a SELECT INTO with an open workbook

Thanks ,,, I did not know that.

regards
JohnM3