Dear Friends,
Could anyone do me a favor in creating a form which can take data from a sheet and upload into SQL Server (My SQL Server is not in local machine , Its a remote machine)
I will keep Database credentials within VBA code only. Thank you in advance. below is sample of a form
Could anyone do me a favor in creating a form which can take data from a sheet and upload into SQL Server (My SQL Server is not in local machine , Its a remote machine)
I will keep Database credentials within VBA code only. Thank you in advance. below is sample of a form
Server | 192.xx.xx.xx | ||
Database | TEST | ||
Table | datadump | ||
Copy From | Sheet1 | ||
Append | Yes | Full Load | x |