Search results for query: *

The tables noted in the OP have no data, only a structure. The data is all in 2 Excel sheets currently - the date is the sort mechanism - one line of data per day. As I learn of the advantages of Access and the limits of Excel it makes sense to transition to Access. Conceptually, all the...

I would appreciate it if someone here could provide input regarding my steps to separate imported Excel data into 3 related tables and advice on how to implement it. Here's more detail - the Excel data is in 2 separate worksheets. Each sheet has a line of data for each day there is a record. I...

The summary data is obtained by this formula =INDEX('07 Summary'!$C$5:$EM$57,$B22,$C$4) Each cell of the summary table has a similar formula (this one is for the 12th week of 2007, there columns in the summary table for the years 2003 through 2008) '07 Summary'!$C$5:$EM$57 is the range where...

Thanks for the reply, To answer the Q's in order: Q: Are you saying that you have different numeric data types in one column? A: That depends on how one interprets it, all columns would have the same type of data at any one time, but by using the menu to select a different variable could lead...

I have a table that summarizes & compares data from several years by week (each year is given 52 weeks for this ongoing effort). Each yearly table has over 100 items that are tabulated by week. All of the data is numerical but some of it is in decimal form and some is in time form - [h]:mm:ss...

Thanks to ArizonaGeek The Linux solution was exactly what was needed. With help from the IT staff, a Linux OS was used to copy the files to another drive and rename them. They are now on my MP3 player. The IT staff informed me that Mac software was used to create the filenames that used the...

Freestone: Thanks for your help but I get the sane error using the * method above. Thank you for your effort.

Freestone: 1) Yes, d: is the drive I am trying to copy from. 2) The media is a CD (already opened so it cannot be returned to store) 3) I tried several variations of what you suggest (replacing the " and ... with ?), no success Before the end quote the ... is one symbol (ellipsis) rather than...

Thanks for the help but Freestone's suggestion did not work I get this result after entering the copy command: d:\02 "Progress is our mission.".mp3 The system cannot find the file specified. 0 file<s> copied Please note that I tried several variations of the ? substitution...

I'd like to know if there is any way to copy a file that has the quote symbol: " in it's file name. EXAMPLE: 02 "Progress is our mission…".mp3 My wife gave me a MP3 CD book but portable CD player does not support MP3 format... No problem I thought. I'll just transfer the file to my MP3...

WOW Thanks for all the feedback!! To clarify a few items: The system will not start in safe mode It hangs at the blue "welcome" screen (not BSOD) No user profiles are set, never got that far w/ install From W98 boot disk at A: , did "Format C:" then reinstall of XP...same result...

I'm attempting to install XP SP2 on an older laptop (it is slightly better than the min sys rqmts for XP: Dell P3 500MHz, 128Mb ram). I understand W98SE would perform better but this will be use for internet 98% of the time and I need to really restrict what other users could do. After the...

PHV, THANK YOU I knew that I was missing something obvious.

Thanks for your reply. I did make several searches of this forum, but most of the replies relate to finding a specific file (I want the user to find the file with an interactive menu simlar to the "Open" dialog box) or an acitive woorkbook. I wish to find the full path of a file that is...

I looking for a macro that I can insert into an Excel file to lookup a file path and return the path as text. Ideally, when the user activates the macro with a button click it would prompt the user, with a dialog box (similar to the "Open" file or "Save as" dialog boxes) to lookup the file...

Frederico and CMP Thanks for your input but, I think it will have limited ability for me since many of the text files I will need to reference exceed Excel's limit for rows (the last output I ran had over 290,000 rows of text). The example data I showed in the original post begins somewhere...

Frederico Thanks for your prompt reply. I am greatful for your help. It looks like I need to study some VBA to better understand your reply. Also it appears that your reply is based on searching an Excel file (although you do note an Access file file be better). My Access skills are very...

I am attempting to write a macro that would retrieve data from text file that could be large (500+ pages of text). The text file is the output of an engineering software package. Currently we manually gather the data to perform calculations that the software package does not handle. What I...

Thanks Brad, This is perfect!

Blank lines will make the data compatable with blank tables already in use. But, if the re-organization could be accomplished without the blank lines, they ciuld easily be added manulally (the objective array will either have 7, 10 or 14 rows of data, so adding blanks is not too bad). Thanks