Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADOBO control of Access Make Table query
I have linked an Excel workbook from a table in an Access database. In order
for the data in the table to be correct it is updated by a "Make table query" in the same Access database. I need to be able to update the query from Excel and have tried the folllowing code Sub UpdateAccess() Dim con As New ADODB.Connection Dim rst As New ADODB.Recordset Dim SQL As String MyFile = "C:\Bas\FTG1.mdb" SQL = "SELECT Levfakt.Levnummer, Levfakt.Fakturadat INTO AAA_Tabell FROM Levfakt" con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MyFile & ";" rst.Open SQL, con, adOpenStatic End Sub My problem is that when I run the code I get an error message stating that "The Table 'AAA_Tabell' arready exists" Any suggestion how to change the code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
execute a make table query in an access database | Excel Programming | |||
Access query feeding spreadsheet control in a user form | Excel Programming | |||
Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
Copy recordset from an Access "make table" query | Excel Programming | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |