From: Bob on
Hello,

Is there any reasonably straightforward way to convert an Excel
spreadsheet, or part of one, to a format that SQL would accept ?

Thanks,
Bob
From: joel on

Usually the method that works is to save the worksheet in CSV format.
Then import the CSV format into your database. Access will import CSV
and so wil a number of other databases.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196450

http://www.thecodecage.com/forumz