Loading dbf Foxpro file from Excel VBA Project
I’m trying to load a dbf file generated from Foxpro7 into Excel (programmatically), I don’t want to use any export/import mechanisms because the objective is to carry out this transparently for the user. Is there any way of doing this using VBA without using any external tool and compatible for x86 and x64 platforms?
try use solution from: https://stackoverflow.com/questions/45224761/viewing-dbf-file-visual-foxpro-9.
You can do export by using shell in VBA to execute command in Visual FoxPro command window (for exemple: https://www.myonlinetraininghub.com/vba-shell)
If you export sucesfully data to .csv or .xls file do standard connection for those files.
You can use simply connection string: https://www.connectionstrings.com/dbf-foxpro/
Excel 2016 OLDBConnection opening Password protected sheet.
I need to know how to open a password protected Excel file using OleDBConnection. I saw a post that provides a work around. I am using Excel 2016. Is there a way in this version? The excel is 2013 and older.0 votes0 answersIsaac Koenig1 week ago
remote connect on a wifi network
Hi, my name is Marvin. I have little experience in mysql I have mysql 5.5 installed with workbench 6.1. I work with vba excel developing small applications, locally I have no problems connecting to databases.0 votes0 answersMarvin Rosal1 month ago
ADO connection string to a shared Excel workbok on Sharepoint
Can I use ADO to open a connection to a shared Excel (Office 365) workbook that resides on SharePoint. I do not want to checkout the work book as Other people are storing information on it.0 votes0 answerszubair Aleem2 months ago
Oracle ODBC x86 and x84 on Excel 32bits.
I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(18.104.22.168) ODBC driver on my Excel.0 votes0 answersLucas Pott3 months ago
Connection string properties
Hi, I use a OdbcConnection string to read xls sheet into a data table (VB.net) is there a property I can use to omit formulas (ex. Vlookup) and use the values instead?0 votes0 answersjos Clement3 months ago
VBA update sharepoint inserts
I think I'm almost there. Except the update is inserting into sharepoint. Using Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0. See code below. Situation: I'm refreshing in an excel table from a power query a Sharepoint list (Sharepoint server 2016).0 votes3 answersThe Dinos6 months ago
Need connection string for Office 2019
I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database. For .xls files, I use the connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...;Extended Properties Excel 8.0;1 vote2 answersMark Cykowski7 months ago
Excel VBA ERROR ODBC connection failed
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.0 votes1 answerKashif Khan8 months ago
How to read values in a particular column of DBF file in c#
How to read values in a particular column of DBF file in c# code0 votes1 answerp bimsara8 months ago
- Load more posts