P
Phredd
For research and productivity purposes we have been entering and uploading pt
testing information in an Access db. It is not intended for use on the Web.
Recently we’ve joined a research Network that will utilize some of our data.
Instead of re-entering data, I would like to upload it, but have encountered
problems and don’t know how to handle it. The other sites enter directly into
the Network db and do not track the other info we do. Our Access db has over
300 fields, but because the data is not collected in the same table, or
queried at the same time, the 255 field limit was never an issue. But now
that each record we’re trying to upload will have 278 fields, it has become a
huge issue. And I don’t know how to get around it.
Is there a better db to use? I looked at File Maker – they have unlimited
fields, but they don’t have a combined date/time field – and most of the
source data we import into Access comes with date and time in the same field.
Oracle is too big & expensive for our purposes.
What can I use to export smaller amounts of data to re-join into one table?.
I don't have any experience with SQL or macros. Excel has the same issue
with number of fields as Access does. The final product ready for import
should be in .csv or .xml format. Expense is an issue.
Any suggestions?
(And please don't start the lectures I've seen on other posts about the max
number of fields, ie, normalization or 'we've never seen so many fields in
one db, so you must being doing something wrong'. The data points are unique
and many, there's a lot of things to track when patients come to the hopital
for testing.)
The bottom line our data is in Access and we need to import 278 fields in
one record to another computer.
testing information in an Access db. It is not intended for use on the Web.
Recently we’ve joined a research Network that will utilize some of our data.
Instead of re-entering data, I would like to upload it, but have encountered
problems and don’t know how to handle it. The other sites enter directly into
the Network db and do not track the other info we do. Our Access db has over
300 fields, but because the data is not collected in the same table, or
queried at the same time, the 255 field limit was never an issue. But now
that each record we’re trying to upload will have 278 fields, it has become a
huge issue. And I don’t know how to get around it.
Is there a better db to use? I looked at File Maker – they have unlimited
fields, but they don’t have a combined date/time field – and most of the
source data we import into Access comes with date and time in the same field.
Oracle is too big & expensive for our purposes.
What can I use to export smaller amounts of data to re-join into one table?.
I don't have any experience with SQL or macros. Excel has the same issue
with number of fields as Access does. The final product ready for import
should be in .csv or .xml format. Expense is an issue.
Any suggestions?
(And please don't start the lectures I've seen on other posts about the max
number of fields, ie, normalization or 'we've never seen so many fields in
one db, so you must being doing something wrong'. The data points are unique
and many, there's a lot of things to track when patients come to the hopital
for testing.)
The bottom line our data is in Access and we need to import 278 fields in
one record to another computer.