Search results for query: *

Hello all, I have a really messy Excel file and was wondering how I would go about selecting data based on the following example (VBA code would be good): A B C D E value 1 n 100 2 n 200 3 n 200 4 n 400...

Hello all, I will be receiving multiple Excel files - they will all have the same format as to where the data is as follows for each file: Type 1 Name 12 John 12 Jane 12 Anyone 34 Mike 34 Celeste Type 2 Name 45 John 45 Jane 45 Anyone 99 Mike 99...

Thanks this worked - I was my intention was to put the commas into the field so that I can delimit upon import - is there an alternative way to import so the field would be delimited based upon spaces between values so: ID Balance 1 2 3 4 2 1 2 4 would be imported as: ID...

Thank you very much however I am getting a syntax error for the first part her is what I put in in the SQL area of my query: Select sample.balance Replace ([Balance]," ",",") From sample;

Hello all, I have a field with the following inside each row stored as text. ID Value 1 21 34 5 2 21 5 3 21 34 I need to do two things 1st I need to update the field "Value" to: ID Value 1 21,34,5 2 21,5 3 21,34 2nd I need to create the table to represent: ID Value...

Hello, I can certainly use a stored procedure instead of just creating a new table -can you briefly outline what would be involved in creating that stored procedure. I will see what I can come up with - I have never created one before but getting a view or stored procedure would work just as...

Hello All, First off many thanks for any help provided. I have one table as follows: Unique ID Purchase Type 1 a 1 b 1 c 2 a 3 a 3 b 4 a 5 a 5 b 5 c Table 1 - need a query to...

sorry I was caught up with cut and paste - you are correct the final table should read Type QTY 1 Distribution 50 2 Distribution 1000 3 Distribution 600 5 Distribution 800 9 Distribution 1000 Balance...

Hello all, I have the following table Type QTY 1 50 2 1000 3 600 5 800 9 1000 12 2500 50 1000 51 1000 55 20 What type of query could I run so that I would end up with the following? Type QTY 1 Distribution 50 2...

Thanks - I am going to take a look at the macro recording suggestion and see what I can up with using DAO as well. Will let you know if I am successful. Celeste.

Hello, Thank you again for the response - essentially I have a series of excel files that I wish to "import" into a currently open workbook's worksheet via a command button. I want to click the command button - browse to the Excel file, select the Excel file and have all information of its...

Hello all, How do I use the: Application.GetOpenFilename("Excel files (*.xls), *.xls") so that the selected Excel file is opened into a new worksheet of he current workbook with the worksheet name the name of the selected excel file from the Application.GetOpenFilename("Excel files (*.xls)...

Thanks for this - I was doing something similar. I do in fact needto generate a table. Unfortunately I have about 40 ID fields and was hoping that I could do this upon import of said table. So instead of importing the table table and then running a series of queries I am trying to "normalize"...

Hello all, I have the following table: UniqueID ID1 ID2 ID3 ID4 1 A B C 2 B C D E 3 A C 4 C D E I would like to make the following table: UniqueID ID 1...