hi. :)

i could do with a bit of help.

i'm trying to append some data from a query into a table via Access VBA.

the code is thus:

INSERT INTO table1 (col1, col2, ...)
SELECT (col1, col2)
FROM [query name]

the problem is that one of the columns is called 'ID*+' and the asterisk in the name is the reason it's not working... can anyone tell me a way to incorporate the asterisk without an error - perhaps with an escape character ?

i would really appreciate any help. thanks in advance,

Tom

First. Change your field name and remove the asterisk. It is not good practice.

you can do a:

SELECT [ID*] from Table1




Sal

thanks I'll give it a try.

and i know it's not good practice but the access frontend is expected to interface with Remedy which forces certain conventions including this one :s

TIP: If a field has a space or special character use [ and ] to wrap the field name so that Access knows it is a field.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com