Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Records 1

Status
Not open for further replies.
jon2002

jon2002

Technical User
Jun 26, 2002
13
GB
I have a couple of spreadsheets with a list of i.e. peoples staff numbers in, I want to quickly use this list to create a SQL Statement to delete (or) add these records from (or) to a database.

Can anyone help me on this please?

Kind Regards
Jon
 
Sort by date Sort by votes
Just import the spreadsheet using the SQL import wizard or DTS. If you want to create sql statemetns, load the spreadsheet into Word and use Edit | Reaplce to Change the raw data to SQL statements. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Adding field duplicates records
Replies
16
Views
206
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
238
Chris Miller
Chris Miller
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
227
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
110
grnzbra
grnzbra
ahmedsa19051985
  • Locked
  • Question
After adding Feature Name and Feature Value query takes more than 5 minutes
Replies
4
Views
117
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top