How to connect excel to sql server by VBA Code, fix ADODB

Показать описание

This video, I use Microsoft Excel 2016 connect to sql server 2014 by VBA Code and add ADO (ActiveX Data Object), but you can use other version(Excel 2007, Excel 2010, Excel 2013) for connecting excel with sql server. I hope this video can help you some .

Рекомендации по теме

Комментарии

i have problem when i try to run this code in vba and then run time error '3001' Arguments are of the wrong type or out of acceptable range or are in conflict with one another.

IkfaYass

Thanks a lot man, that was really helpful.

devops_junkie

This was very helpful to me. Thank you.

forum

Hi thank you for the video, I am getting the following errr while executing. ". Error when compiling: Function call on the left side of the assignment must return the type Variant or Object". and does it work exactly the same with mysql as well? waiting for your reply

renukapasupuleti

I am getting run time error for cn.open strconn.

error - data source name not found and no default driver specified

a.rakeshpatro

getting run time error data source name not found and no default driver specified.., please help

raviyadav-ocbv

Salut je une petite problème et le problème est que je voulais connecté les tables Access sur des UserForm de Excel. Merci pour votre réponse

reagansendwe

Hello, I need a codigfo in vba to get the data from the Access database and put it in the SQL server, always overlapping every new incersion, thanks in advance. weber

weberrodrigues

ActiveX is no longer supported in Office/Win 64bit editions. So you have to use ODBCConnection object which is inbuilt into Excel. ActiveX is dead!

LatinoTropico

@E Angkor - wow, awesome! could you please add excel/oracle connection? I've got an error in my macro after installed Windows 10. (Runtime error '-2147467259 (80004005)': Error while trying to retrieve text for error ORA-01019)

I've already test with...
MSDAORA.Oracle
MSDAORA.1
OLEDB and so on..

rokrman

Could you please share the source with us?

JobQuestUnveiled

How to connect excel to sql server by VBA Code, fix ADODB

Excel - Link Data Between Worksheets in a Workbook in Excel

Advanced Excel 2019: Connecting Excel to the Web (Microsoft Excel Tutorial)

How to Link Cells in Different Excel Spreadsheets (In One or More Excel files)

How to Link Data in Excel from One Sheet to Another

Advanced Excel 2019: Connecting Excel to Access (Microsoft Excel Tutorial)

How to connect two tables in Excel - With Example Workbook

How to Connect Salesforce With Excel in 2 Minutes

How to Connect Microsoft Excel with Google Sheets | Auto-Sync Google Sheets with Excel

How to use CHATGPT to do Excel REGEX and is TRIMRANGE useful?

How to link two files in Excel - 2 ways to solve the problem

Here's how you merge multiple Excel files into one🤯 #excel #exceltricks #exceltips #exceltutori...

Auto-Sync Data from Excel to Google Sheets

Use Excel to Connect to SQL Server Data

How to connect Excel to Oracle with VBA

How to Link Data Between Word & Excel : Microsoft Excel Tips

Link Every Worksheet to a Master Sheet in Excel

How to connect to an Excel or CSV File on SharePoint / OneDrive using Power Query

Different ways to work with Microsoft Excel in Power BI (2023)

LINKING DATA FROM EXCEL TO WORD || EXCEL

Combine Text from Multiple Cells into One Cell in Excel

Connecting to Excel in SharePoint Online from Power Query (Lazy Tutorial)

Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

How to Link Excel to PowerPoint | Excel to PPT

Merge OR Concatenate two columns in Ms Excel