HI
i was reading allen brownes guides in particular this one http://allenbrowne.com/casu-06.html .
I am setting up my tables now but am wondering if there is a good guide or how-to on pulling a data sources (csv, xml or excel) file into multiple tables.
Most examples I find show how to bring data into one table via import but realistically that isn't going to happen very often. This must be a fairly common question can access 2007 do this standard or do I need to use vba to code a solution?
i was reading allen brownes guides in particular this one http://allenbrowne.com/casu-06.html .
I am setting up my tables now but am wondering if there is a good guide or how-to on pulling a data sources (csv, xml or excel) file into multiple tables.
Most examples I find show how to bring data into one table via import but realistically that isn't going to happen very often. This must be a fairly common question can access 2007 do this standard or do I need to use vba to code a solution?