Click here to Skip to main content
15,499,289 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming6-Apr-20 2:19
mveRichard Deeming6-Apr-20 2:19 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx6-Apr-20 8:28
professionaljkirkerx6-Apr-20 8:28 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming6-Apr-20 9:01
mveRichard Deeming6-Apr-20 9:01 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx6-Apr-20 10:20
professionaljkirkerx6-Apr-20 10:20 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming7-Apr-20 1:30
mveRichard Deeming7-Apr-20 1:30 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx7-Apr-20 8:05
professionaljkirkerx7-Apr-20 8:05 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx8-Apr-20 10:24
professionaljkirkerx8-Apr-20 10:24 
QuestionHow to update sql server data from excel data using VBA code by all User Pin
Member 1478441627-Mar-20 1:25
MemberMember 1478441627-Mar-20 1:25 
Hi Team,

I have an Excel file that has data and a table in SQL server.
I am doing it by excel VBA code in "Audit Query Report" Consolidation.
Hence, I want to do a Consolidated report by all Users in the SQL Table. Each User data to Update\Insert in DB once click the macro button in excel, Even I existing data to replaced, New Data should add in DB.

I googled it, unfortunately, there is no related code as my per requirement, Kindly advise best way code to make a consolidation DB, am finance Background, am not much familiar SQL code through VBA.
AnswerRe: How to update sql server data from excel data using VBA code by all User Pin
ZurdoDev27-Mar-20 2:19
professionalZurdoDev27-Mar-20 2:19 
GeneralRe: How to update sql server data from excel data using VBA code by all User Pin
Member 1478441627-Mar-20 3:17
MemberMember 1478441627-Mar-20 3:17 
Questionevent handler Pin
Member 1356965022-Mar-20 0:16
MemberMember 1356965022-Mar-20 0:16 
AnswerRe: event handler Pin
Richard MacCutchan22-Mar-20 0:31
mveRichard MacCutchan22-Mar-20 0:31 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 1:24
MemberMember 1356965022-Mar-20 1:24 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 1:33
mveRichard MacCutchan22-Mar-20 1:33 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 2:04
MemberMember 1356965022-Mar-20 2:04 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 5:03
mveRichard MacCutchan22-Mar-20 5:03 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 5:18
MemberMember 1356965022-Mar-20 5:18 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 5:47
mveRichard MacCutchan22-Mar-20 5:47 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 6:01
MemberMember 1356965022-Mar-20 6:01 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 6:12
mveRichard MacCutchan22-Mar-20 6:12 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 6:11
mveRichard MacCutchan22-Mar-20 6:11 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 6:48
MemberMember 1356965022-Mar-20 6:48 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 6:52
mveRichard MacCutchan22-Mar-20 6:52 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 6:52
MemberMember 1356965022-Mar-20 6:52 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 6:53
mveRichard MacCutchan22-Mar-20 6:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.