P
Plateriot
I have a named range called BPEntry that I would like to write to SQL Server
2000 on the click of a button..
The range has the fields EntryDate, SBP, DBP, HR
The table in SQL 2000 has the same fields and a couple of extra ones that I
would like to adjust the insert using VBA with my own SQL String. After it
writes it to SQL Server as set of values with a Serial number, I will clear
the named range "BPEntry" so that the user can enter more values - which I
will add a set to.
I find a lot of articles using named ranges, so I was wondering if this is
possible.
I'm writing an app in Excel, because the user prefers to enter using a
spreadsheet.
2000 on the click of a button..
The range has the fields EntryDate, SBP, DBP, HR
The table in SQL 2000 has the same fields and a couple of extra ones that I
would like to adjust the insert using VBA with my own SQL String. After it
writes it to SQL Server as set of values with a Serial number, I will clear
the named range "BPEntry" so that the user can enter more values - which I
will add a set to.
I find a lot of articles using named ranges, so I was wondering if this is
possible.
I'm writing an app in Excel, because the user prefers to enter using a
spreadsheet.