Link to home
Create AccountLog in
Avatar of vonfranzken
vonfranzken

asked on

Update Database Table from Spreadsheet

I have a spreadsheet called longlat.csv.

It has the corresonding id feild PK and longitude and latitude feilds

I want to update the table garages so that it updates the table to the corresonding id from the csv file

How would I write this using SQL 2000 Query Analyzer?
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account