Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by scheung

  1. scheung

    How to append records from Access database to MS-SQL database

    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...
  2. scheung

    How to append records from Access database to MS-SQL database

    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
  3. scheung

    How to append records from Access database to MS-SQL database

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

    How to append records from Access database to MS-SQL database

    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]"...
  5. scheung

    How to append records from Access database to MS-SQL database

    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?
  6. scheung

    How to append records from Access database to MS-SQL database

    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...
See more

Part and Inventory Search

Back
Top