Web Development
Currently I have lots of structured excel documents that need to be indexed.
How can I do automatic indexing that will store certain fields in the excel documents to access database for easy retrieve?
by rdwilson2
Basically, it depends on how the Excel docs are structured, what you want to import into Access, whether the Excel docs have a common set of columns to be imported, and a lot of other "little" things like that.
You can probably create a batch job that creates a list of the files you would want to import data from. That could be imported and used to drive an Access process that would then import a set of columns from each of the files in the the list. By retaining that list in an Access table, you could preclude the duplicatation in the data importing process.
On the other hand, you might want to consider whether Excel is the proper place for the original dat in the first place.
by rdwilson2
Basically, it depends on how the Excel docs are structured, what you want to import into Access, whether the Excel docs have a common set of columns to be imported, and a lot of other "little" things like that.
You can probably create a batch job that creates a list of the files you would want to import data from. That could be imported and used to drive an Access process that would then import a set of columns from each of the files in the the list. By retaining that list in an Access table, you could preclude the duplicatation in the data importing process.
On the other hand, you might want to consider whether Excel is the proper place for the original dat in the first place.
by bong06
by bong06
This discussion is closed to new replies.
Sort by Trending