Search results for query: *

I have done something which may be similiar to what you are trying to do. I have a VB app that uses Word functionality. Basically we have a database that among other things we use to create form letters which I use Word to do. I create an object of Word Basic in my VB app and using it I can...

RonB,<br> <br> You must choose the database that you will be importing from. Then in the dialog box that shows the list of tables, queries, etc. to choose there is an options button on the bottom.

If your code is written exactly as you have it listed in your message, I believe all you did was forget to wrap single quotes around your variable. You will need to do this since BatchNo is of type string. If it should be a number, change your declaration statement or if it is indeed a string...

I believe you could also use code that looks like this:<br> <br> Dim sVariable as String<br> <br> sVariable = DBEngine(0).Databases(0).Name

jimihndrks,<br> <br> Don't know if you are still looking for help on this problem. I have done the same thing you are trying to do, and it works fine. May seem like a silly question, but did you link the table or import it? Obviously linking is what you want to do.