Cloudbase: This should sort it
http://www.microsoft.com/athome/security/spyware/software/about/productcomparisons.mspx

Ian, thanks.
I've run the removal software and it says no infection found, hmmm.

Just to be sure, try Spybot

http://www.safer-networking.org/en/download/

Panda online scan is useful, I have used it a few times recently and its pretty comprehensive it will take a while to do a full scan though. Its here Panda Activescan

Ian,Spaceman......Thanks, it seems non of these will remove them, i still get
Virus Detected box from my AVG scan and it won't let you either heal or move to vault. A message box pops up saying "Requested action is not available for this object. Access to the file has been denied"
Any thaughts.

cloudbase did panda find an infection?

Hi

ive got some data that i want to analyse. The data is posted as a downloadable file on a webpage in a comma separated values excel file. However, the file is over 65536 lines long hence will only partially open in Excel. Can anyone recommend the best way of being able to open this whole file please.

fundy, access?

Is it feasible to open the data in access without having created the database first?

Spaceman.......Panda found 38 spyware items but no viruses, should it have picked up a Trojan?

Spyware (or 'Malware') may be (or may not be) Trojans.

DocProc....thanks for that, will keep my fingers crossed its got them cornered.

Sorry to be back on about my wretched database. I'm struggling to see how I can turn the existing spreadsheet (created in Exel) into an Access database. I think I must have pressed all the options on every tab - but nothing seems to transform the data into an Access database. Could anybody help, please?

I'm just guessing, P, as I haven't looked how to do it and am wide open to correction, but I would've thought that you first need to create a database in Access by putting all of the fields in the right places ready to accept values.

Then export your Excel data to a csv file and import the csv file into Access. There may even be an export function to export directly into Access without going the csv route.

A 'csv' file, Hils?

I was looking for an export function but maybe until I create the database, as you suggest, perhaps it won't register.

P,

A quick look at Access 2k3 shows that you can open the Excel .xls file directly in Access without going the csv route. Don't have time now to play about with it unfortunately.

Good luck with it.

edit: csv = comma separated values. The comma (or any another specified character) separates the contents of one cell (or field) from the next.

The export will be on Excel. In fact it would probably be 'save as' and one of the file types would be csv. I am assuming that you have it in Excel format. If you have it in csv already then it will be an import into Access. As you say, you need to define the database first.

Never mess with a dodgy photocopier!

Copy machine revenge

(or 'Pinky the cat) :-)

Thanks, guys. I found the 'Save As.csv' option and I'm tackling the define the database bit.

Grrrh! Almost there. Only problem I'm left with is all the imported information is in one field. Something about which delimiter I'm using. I can't get the info to go into the nice separate llittle fields I've created for them.

Has the data got saved properly with commas or "," around the fields? Look at it with wordpad (notepad may not allow a file that big).