Thank you very much Terry,
I'll archive your advice.
I am about to follow this advice firstly.......
Hi rodney,
Checkout
www.dbfview.com/. May be what you need.
Hi Rodney,
Another place to check out if you don't mind working in DOS.
http://usuarios.lycos.es/scratchupload
I have also been offered off list for someone to do it for me for $100 US
| Rodney,
|
| Best option is to find someone with access and use that to
| get the dbase file in and split.
|
| Another option (potentially fraut with problems) is to
| open it with notepad (assuming you are using NT /
| 2000 /XP). Copy sections of the file to new ones (less
| than 64k rows). The danger here is that the dbase file
| headers and footers will need some massaging to maintain
| file integrity for the resultent smaller files. I am not a
| dbase person and do not know what is required. A look with
| notepad may make this apparent (maybe not???)
|
| Another option may be to use MSQuery from Excel to import
| a subset of the records into excel. I am fairly sure
| MSQuery will open a dbase file. You would need to
| structure your query to have it return less than 64k rows.
|
| HTH,
|
| Terry
|
| >-----Original Message-----
| >I have a large *.dbf file
| >I need to get into Excel.
| >
| >I presume the file is about 140,000 records
| >therefore opening in Excel or MSWorks will not
| >display all records.
| >
| >I do not have access, is there any other way
| >I can open this file to get the data into several
| >excel workdsheets?
| >
| >Thanks
| >
| >
| >
| >.
| >
