excel import

I'm using Excel Professional Plus 2016 to connect to an external SQL Server connection. First, I pull the data into the Excel sheet and now see the data that exists based on my query criteria. [Shown as columns A,B,C] After that, I'm adding new manual columns that do not exist in the external...

I have imported data from external source, that data gets automatic refresh after 15 minutes I have such 10 sheets in one workbook. when I am trying for 5 sheets it works very well but when i try for 10 sheets in one workbook it just shows "connecting to web" and does nothing. kindly help with...

I have various workbooks that I've used for years to import data from .csv (text) files that were downloaded from my company system. These were run using buttons and Querytable Refresh macros, and worked beautifully, omitting unwanted data, maintaining my formats and updating/inserting...

Hello Im trying to integrate Excel with proe wildfire.4 and able to export the dimensions to Excel Sheet. But when i try to link a dimension with tolerance limit only the Mean Dimension getting Imported. Is there any way i can import tolerance also from 3D Model to Excel?

i have a workbook name as ColorDB and 2 sheets inside that workbook. The Sheets are named as "CNT" and the other one as "PPB". I have a macro button inserted onto the "PPB" sheet. when i click that macro button , i would like to browse and open a .dat file and import the data onto the same sheet...

Is there a way I can import data from a site that require a password to access it , my boss gave me two site Nlaride.com and Avinode.com from me to import the directory , there is almost 3000 listing and I need to have it done by 5:30 today web query will not retrieve The listing , is there...

Hi All- I am attempting to create a template that will utilize data from an Access table, and allow the user to select the parameters in the Excel file. The amount of records in this table is slowing down the Excel file, and I would like to lessen the amount of data that is imported based on...

I want to import couple of excel files in my data. Below are the details of 1 of the excel file. I would like to have a simple VB code or some macro or query to import the data<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Excel File Name...