TomasCrossroads
Programmer
Hello,
I'm writing an email application. I want one part of my site to control the client database. The idea is that we host the database and that a client can import data to it.
I want to create some page that will invite the user to import data to our database. The client should have a couple of choices for his data source: CSV, excel, access, ...
Is there anything out there that can help me with this. I need to have scripting that can read from this different data sources into a recordset. Once that is achieved, I can write it out to our own databse.
The user should also be able to point out which field of his own data source match with our structure. For example, we have columns Name, Email, etc... well the user should be able to tell us which columns in his data source are the ones for Name, Email and so on.
There's another problem: when I allow text files as a data source, sometimes first row contains field names, sometimes not, delimiter can be different every time...
Any ideas on how I should tackle this problem?
Thanks for any hints,
Greetings
I'm writing an email application. I want one part of my site to control the client database. The idea is that we host the database and that a client can import data to it.
I want to create some page that will invite the user to import data to our database. The client should have a couple of choices for his data source: CSV, excel, access, ...
Is there anything out there that can help me with this. I need to have scripting that can read from this different data sources into a recordset. Once that is achieved, I can write it out to our own databse.
The user should also be able to point out which field of his own data source match with our structure. For example, we have columns Name, Email, etc... well the user should be able to tell us which columns in his data source are the ones for Name, Email and so on.
There's another problem: when I allow text files as a data source, sometimes first row contains field names, sometimes not, delimiter can be different every time...
Any ideas on how I should tackle this problem?
Thanks for any hints,
Greetings