Search results for query: *

With respect, I dont undestand your objections. You have no idea of the 'context' in which I am asking for help nor the sensitivity of data (in this example, a list of health authorities and addresses - nothing more) I am dissappointed with the hostile response to my posts and I will find some...

Look, understand your concern but I have a problem and I would like to focus on the original question please? Can you help with my original query? SC

Thanks for your useful comments. I am working with an offline test Access database - which is why its on my local drive. SC

I got a bit further since my last post but still can figure out what I'm doing wrong. Here is my VBA code so far: Sub CopyDataToSQL() Dim strAccessTableName As String Dim strSQLTableName As String Dim strSQL As String strAccessTableName = "[tblHealthAuthority]"...

Thank you for replying to my post. The table in my Access database is temporary and is created just before I need to copy the records into the SQL database table (and then subsequently deleted afterwards by the program). Can I still use an append query to a linked table?

How do I copy records from an Access (2000) database table to a MS-SQL (2005) table using VBA code? The tables in my Access and MS-SQL databases already exist and have identical table structures. I need to copy all the records from my Access database table to the SQL database table. I'm using...