Recent content by WuJu

Hello, I redirect the question, so that a little more clear. I want to know how link to the Excel spreadsheet and then create an append query that selects columns from the linked Excel spreadsheet and appends them to the columns you select in the Access table? I have about 750 excel...

Hello, Could you let me know how link to the Excel spreadsheet and then create an append query that selects columns from the linked Excel spreadsheet and appends them to the columns you select in the Access table? I have about 750 excel files(each file has one worksheet) in a directory...

hello Mr. B I have two projects that I need to import multiple excel files with FILTERED Excel spreasheet into an access table. One I described yesterday is okay for your method since excel has first row with good index such as ID, month, year, .... For my second project, I don't have good...

Hi. I have thousands of excel files in one directory. I want to build up the Access table from excel files. Each excel file has one worksheet, but I don't need every column and low of the worksheet. I am trying to import a FILTERED Excel worksheet of every excel files in that directory into...

Thank Spentgeezer for VBA code and boblarson for tip. Spentgeezer's VBA code will definately help me for converting. wuju

Howdy, I need to convert some records (not all) in my access table to match with same unit. I have a access table with mismatch in unit: some in kilowatt and some in megawatt. I want to unify unit in megawatt and update the table. The following is the access table I have with fields pID...

I was able to generate query output that has the order of columns: unitID, Date, Hour, KWh. Could you let me know how to make this query output to a table form (with the index of unitID,date,Hour combination)? Brian mentioned that 24 queries could be 24 append to table queries. But this is not...

Thanks Paul for your quick respond. I will try your UNION query. Final product has to be in table format, not query. So can this output from query be a table (with index which made of UnitID, date, and Hour combine)? By the way, I may need to do this in VBA in MS Access (with someone's...

Hello VBA scripters, I need help on converting multiple columns into one row (actually two rows). I have a Access table with 26 columns UnitID, Date, 1, 2, 3, 4,.......,24. (data in column "1" means KWh used in hour 1, and samething appplies to each hour until hour 24) I want to convert...

I want to automate data converting (import) task from 2003 Excel to 2007 Access using visual basic. There is an obstacle. Data in Excel are different format than I want to have in Access table, so can’t just use built-in importing step in Access. What is the best way to automate...

Hello Husan and Gemma, Thank you for your input and help. First of all, I finally found a solution. It is the combination of Husan's option 1 and "UNION" Gemma, I will try to work with your input : make intermediate tables for current and previous, and simply subtract each other. Once I am...

Hello Husan, I tried your option 1. It was beatifully working for everyday for hour 2 - hour1, hour3 - hour2, ..... hour 24- hour23. However, I also need to the day hour 1 - previous day 24 except the first day. So if I am calculating for period january 1, 2005 to December 31, 2009, then I...

Thanks John, Gemma, and Husan. I will try all of your suggestions. John, I will try your ranking method to generate ID and use Dlookup to see if it works for me. Thanks. Gemma, could you advise me how to store previous reading with each record? Do you have same idea as Husan's first...

Thanks for your advise, but when I need the difference from the current record to previous record, I only subtract recrod one behind current record. (Tot - current record) is all the value of sum of the all the previous records. I need to do (Current record - adjacent (just one behind)...

Thanks for your help. The link that you addressed was good for sum up the total of previous records. I don't need to sum up, but need to subtract individual current record to the just one behind previous record. DSUM doesn't give me the subtraction of individual previous value. Thank you for...