import external data

  1. R

    Import data from workbooks, convert them and paste it in "main" Workbook

    Hello MrExcel forumers and experts, For sometime now I'm facing this problem I have and I'm hoping that you guys can help me solve it. I've tried using the advanced search but none really solve the exact issue I'm having. Here it goes: I need help extracting and editing data from several...
  2. A

    Import Historical Currency Excahange Rates from Yahoo

    Can anyone please help here? Is it possible to import yahoo currency exchange rates from Currency Converter - Yahoo! Finance or any other reliable source for a specific date for specific currency pair (i.e. USD/EUR) ? Thank you!!
  3. N

    Importing many text files from same folder

    Hi all, I have a macro which currently imports a text file, delimits it, and copies specific data from it to add to a summary table of data. As it stands, I have to open each file individually for the macro to be able to pull the data out, and depending on the project, there could be as many...
  4. R

    Import Text Wizard issues

    Hi I have a text file containing data which shows correctly in a web browser, looks like garbage in notepad, then when i import it through the text wizard using space as the delimiter it shows correctly except that some of the rows are shifted across by one column and others aren't. For example...
  5. F

    unique problem regarding importing data from excel to excel

    I have a unique problem in importing data from excel table to another excel table File 1: has few column table.. all columns have text and time format data.. when i am importing this table in another file with the help of "Get external Data". it is importing data only as "text" (which is...
  6. M

    Over-Controling How Data Imports In Excel

    I have a query that pulls data from my database. The basic query looks like this: SELECT ClosedDate, ServiceRequestID FROM MyDatabaseNameHere Now SQL runs this and all my dates are in the basic format. (YYYY-MM-DD MM:SS:nnn) :( Since this is not user friendly I modify my query with Convert...
  7. M

    Import Excel Data Not Working With Dynamic Named Range

    Hi all. This may exist here already, but my searches have been futile so far. I have a dynamic named range (using offset) in an Excel file. When I try to import the data into Access, the dynamic range doesn't appear in the list of named ranges. If I change the range to a fixed area...
  8. S

    Is there something wrong with my database?

    Hi I am trying the import data into excel (using excel data menu) from a table/query I have made in Access so I can then use a little macro to refresh it automatically. But I am having challenges... This works with other tables but not the ones I have built, anyone know what I am doing...
  9. S

    Import external data into Excel from Access, Having problems, please help?!

    Hi I am trying the import data into excel (using excel data menu) from a table/query I have made in Access so I can then use a little macro to refresh it automatically. But I am having challenges... This works with other tables but not the ones I have built, anyone know what I am doing...
  10. W

    Lose reference to external data when moving files

    Hi Can anyone help with the following Excel 2003 problem please? I have an external access database, currently held in the same folder as an excel file. I have set the excel file up to call this information using data>import external data and it refreshes on opening. I now need to move both...
  11. F

    Import Metatrader 4 Indicator Data to Excel

    Hello, I wish to import the Metatrader 4 "BULL" indicator data, (one live changing number) into an Excel cell. Then, I can use this cell to make normal/easy calculations. I have some knowledge in Excell, but kindly request step by step instructions. Another alternative is to leave your...
  12. B

    Auto-update external images

    Hi, I am producing tables and images outside Excel 2003 and want to auto-update them in a Excel file. The file names stay the same but the images themselves change (they're graphs created by an external software). I found instructions on auto-updating external tables but I cannot find any...
  13. S

    Import Google Spreadsheet Data into Excel 2007

    Hi, Anyone heard of a decent way to import spreadsheet data from Google Spreadsheets into an excel document so the resulting excel spreadsheet has live updatable google spreadsheet data? Regards Steve Flavel Pharmacist from Queensland, Australia
  14. H

    Choosing columns in Microsoft Query from Excel

    I am using Microsoft Query within Excel (ver. 2003) to bring in certain data from several tables currently stored in Microsoft Access. Following is a quick walk through of the steps I am using. From the Data menu, I am selecting “Import External Data” and then “New Database Query…”. Then when...
  15. C

    Using VBA to clean up imported data

    I receive data from an old system that does not format the data in a table format. It takes hours for me to clean up the data so I can use pivot tables, etc. to summarize the data. Does anyone know how to write VBA to do this automatically? I am new to VBA. Doing this manually takes hours. I...
  16. C

    Import External data through Database query

    Hi, I'm writing a macro to import data using the Import External Data function. This is new to me and I used someone else's code as a guideline. Here is my code: Sub SQLQuery2() Sheets("RawData").Select Cells.Select Selection.ClearContents Uname = sheetMain.txtUNAME...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top