I believe these are database .csv files, and I need them translated/combined? into Excel (one file, multiple sheets?) so that I can use the data.
Export from database files into Excel
The files are found here. They are large. <[url removed, login to view]>
and see the root page with all of the info: <[url removed, login to view]>
Additional files needed for this may be found at <[url removed, login to view]>
and maybe here
<[url removed, login to view]>
We're using Excel 2007
Basically, the huge database file has revenue/expense data on nursing homes (SNFs) in the USA. There is a definitions file somewhere here showing how all the forms map to the database. We want to extract from the database to see the data in the right places of the form.
Each SNF files one cost report for the year, and each cost report has many pages with many data fields each page. We want to work with the latest year of data available -- 2008?
On the attached Excel [url removed, login to view] file, this is what the cost reports look like. This file comes from one of those above links. On this file, you can see the six sheets I need which are:
I need to be able to query for a nursing home's name and export the data to have all of these forms filled out with that facility's data.
Once you're successful with this project, I plan to re-hire you to update each year with the next year's data.
Maybe this project can be done by embedding SQL into an Excel spreadsheet, or maybe by linking from Access to Excel.
* * *This broadcast message was sent to all bidders on Friday Nov 27, 2009 9:15:54 PM:
FYI to all bidders: the large 2008 database file is found at: [url removed, login to view]