Prev: How to sort names in alphabetical ascending order?
Next: Pasting in Excel has started taking a long time.
From: Bob on 18 Apr 2010 07:18
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 18 Apr 2010 08:52

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

 | 
Pages: 1
Prev: How to sort names in alphabetical ascending order?
Next: Pasting in Excel has started taking a long time.