hello

this is in relation to my last post with regards to speeding up the import of a spreadsheet. i have managed to get the following function to work, as pointed out by adowcra (thanks)

strSQL _
= "Select * " _
& " INTO " & strAccessTable & " " _
& " IN " & """" & strAccessPath & """ " _
& " FROM [" & strExcelSheet & "] "
m_cnExcel.Execute strSQL


however my problem is i need to append to a table, this function when run twice will simply state the table allready exists and therefore cannot carry out the function.

i have got as far as the following

strSQL _
= "Insert *" _
& " INTO " & strAccessTable & " " _
& " IN " & """" & strAccessPath & """ " _
& " FROM [" & strExcelSheet & "] "
m_cnExcel.Execute strSQL

i am trying to change the sql bit to an append form however i recieve syntax error. does any 1 know how i can append the data to a table, or the correct syntax. Pls help i have been trying to solve this all mornin to no avail


thanks in advance