Maikel
09-23-2010, 08:03 AM
Hey all,
Is there anyone who can give me some advice in regard to creating an excel database, without usage of access. I'd like to use 2 excel files for this. One which contains all data and the other who functions as an input form.
I haven't been able to find any information on the web regarding this. Because they're almost all related to creating a link between Excel and Access.
If anyone knows some link(s) i might have missed or can give some information regarding how to set it up that would be greatly appreciated.
Especially because i think excel has some database functions without having to manually make the code to for example store some fields in an external file without having to check it's size , if it's already in the database (data checker) and adding the fields based on field / header names instead of cell ranges.
Is there anyone who can give me some advice in regard to creating an excel database, without usage of access. I'd like to use 2 excel files for this. One which contains all data and the other who functions as an input form.
I haven't been able to find any information on the web regarding this. Because they're almost all related to creating a link between Excel and Access.
If anyone knows some link(s) i might have missed or can give some information regarding how to set it up that would be greatly appreciated.
Especially because i think excel has some database functions without having to manually make the code to for example store some fields in an external file without having to check it's size , if it's already in the database (data checker) and adding the fields based on field / header names instead of cell ranges.