Well... You need to write a script that does this:<BR>1) Opens the Excel spreadsheet<BR>2) Loads data from the spreadsheet into memory<BR>3) Loops through the data in memory<BR>4) Inserts the data into the database.<BR><BR>Where exactly are you having a problem?<BR><BR>Craig.
You can "talk" to Excel as it's ODBC-compatible. It's just fiddly pulling all the bits back. Your best bet is to start with a tutorial.<BR><BR>If you want someone else to write the code for you, then I don't think anyone here has the time to sit down and do it all for you. As Doug said - if you PAID someone, then they'd make the time. But coming onto a free board like this and showing absolutely no initiative isn't going to get you far.<BR><BR>Craig.