Getting the excel coordinates with oledb

L

Leandro Oliveira

Joined
May 26, 2014
Messages
1
Reaction score
0
Hi There!
I'm trying to get the coordinates values in my excel file to update after using Oledb, For exemple I get the value "test" related coordinates A21, i want to get as well the value "A21" because after that, I want to update my value "test" to "City"


UPDATE [Sheet3$] SET A21 ='City'; -- it's possible ?

Pleeease, i really need help :cry:
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Handling nonexistant coordinates? 3
Excel Bilinear interpolation 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
prob in IF then else statement 1
Coding issue with Excel 2003 1
Need to fill in map coordinates for addresses 2
Macro to copy value in field and insert it into filter 2
GPS Coordinates 3

Top