Question Upload data automatically

[BRABUS]

Hi,

Silly question I am sure but I have tried searching and so far found nothing to help me.

I have a database with a table containing customer jobs. I want to update certain fields on each record each week using data from a spreadsheet (not ideal but its the way its supplied).

How do I go through the spreadsheet and only update certain fields contained in it for those records??

thanks.

 

[DCrake]

Alot will depend on how the layout of the spreadsheet is. If done correctly you can simply create link to it and use update queries to perform the updates. Have you got a sample of the spreadsheet to look at.

David

 

[BRABUS]

The spreadsheet is very simple. It has 4 columns, the first is a text field and the other 3 are currency. The database table is only 7 fields, the first 4 fields are laid out exactly as the spreadsheet with the 3 following fields just being text that shouldnt be impacted by the update.

The reason I need to do this in an automated way is that I have to update over 10,000 records in this table each week, and doing it manually as I do at the moment is driving me up the wall

I hope that helps (struggling to upload an example )