Question about TrackRecord(compuware) and Excel
Is it possible to write data back to database through Excel. In the example provided in the software, the Excel can retrieve the data from trackRecord database but i am not sure whether it is possible to update the data through Excel.
Re: Question about TrackRecord(compuware) and Excel
Not sure I totally follow your question, but I think you are asking if you can import data into TrackRecord from Excel.
The answer to that is, yes. You will want to open the data in Excel and do a "Save As". Give it a file name and select .txt as the type.
Keep in mind that this will save to a delimited text file. You will find the trick is to clean your data in Excel before you do the export. To clean your data you want to strip out all the delimiter characters form your database.
Do not try to import more than 250 records at a time as TrackRecord will crash. Just break up the import file into separate, 250 record, files.