import external data

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...

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!!

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...