<div>
<p>My Access DB currently connects to Oracle, downloads data and creates an Excel worksheet.&nbsp;</p>
</div>


Data Analyst

Lia Nungaray

<div>
<div class="content wysiwyg-content fr-view">
<p>Hello Experts. I use the following connection to connect my MS Access DB to Oracle:</p><p><br></p><p>strConnect = "ODBC;DSN=oracle;DBQ=myDB;DBA=W;APA=T;UID=myLogin;PWD=myPsswd;=EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;".&nbsp;</p><p><br></p><p>I would like to connect the Access DB to Snowflake. Is this possible? Thank you</p>
</div>
</div>



Hello Experts. I use the following connection to connect my MS Access DB to Oracle:
strConnect = "ODBC;DSN=oracle;DBQ=myDB;DBA=W;APA=T;UID=myLogin;PWD=myPsswd;=EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;". 
I would like to connect the Access DB to Snowflake. Is this possible? Thank you


My Access DB currently connects to Oracle, downloads data and creates an Excel worksheet. 

How to connect MS Access to a Snowflake DB


Hello Experts. I use the following connection to connect my MS Access DB to Oracle:
strConnect = &quot;ODBC;DSN=oracle;DBQ=myDB;DBA=W;APA=T;UID=myLogin;PWD=myPsswd;=EXC=F;FEN=T;QTO=F;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;&quot;. 
I would like to connect the Access DB to Snowflake. Is this possible? Thank you

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.