Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
Hi, Guys
Need some help.
We have 500 customer records. Each is a separate xls file. The fields are
either labels, eg Name, Address etc, and either text or number content.
The problem is that they are not set up as data files, laid out like a
paper form, with centred / merged cells. Basically they have used the PC as
a typewriter to fill in the form. [I'm on the Mac, the forms were created
using Office04 Win].
Now I have to get all those data out of the files and load into a new
database, which wants CSV or similar structured data - and does NOT want
any formatting.
Any suggestions? Please?
Ken
I now need to combine all 500
|
