Save Excel to Database Table or Stored Procedure?

richarrd

New member
Joined
Jul 2, 2012
Messages
5
Reaction score
0
Points
0
Please can you tell me the easiest way to validate and upload Excel data to Database table or stored procedure - (preferably without code).

Thanks
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Without code? Save the data to a csv and then goto the database manager and import it.
 

richarrd

New member
Joined
Jul 2, 2012
Messages
5
Reaction score
0
Points
0
software

Without code? Save the data to a csv and then goto the database manager and import it.

Thanks Bob,

I have been trying to do this but wanted some pre-validation.

I have been having a go with the 'Excel to Database utility' software I found.

So far so good..
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
What utility is that?
 
Top