By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,222 Members | 1,436 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,222 IT Pros & Developers. It's quick & easy.

Update Access from Excel via SQL

P: n/a
The following SQL statement, used in VBScript,
will COPY a table from Excel to an Access mdb.

SQL = "SELECT * INTO C1R0" & _
" FROM [C1R0$] IN ''" & _
" 'Excel 8.0;database=c:\excel\UpdateFinal1.xls';"
What is the SQL statement that will
UPDATE an already existing Access table
with all rows from Excel spreadsheet?

The columns of both Spreadsheet and database are the
same.

Thanks
Jim

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I don't know if you can do it that way. You could write a script which will
import the data from the excel spreadsheet, and write a second query which
will update your SQL table with the imported excel table..

Linda

<ji******@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
The following SQL statement, used in VBScript,
will COPY a table from Excel to an Access mdb.

SQL = "SELECT * INTO C1R0" & _
" FROM [C1R0$] IN ''" & _
" 'Excel 8.0;database=c:\excel\UpdateFinal1.xls';"
What is the SQL statement that will
UPDATE an already existing Access table
with all rows from Excel spreadsheet?

The columns of both Spreadsheet and database are the
same.

Thanks
Jim

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.