Multiple imports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been asked to look at building an application which will ultimately
import various sources of data, I have limited knowledge of Access and know
you can link to say Excel, but I have been asked to see if it can link to
Word and Intranet (Internal internet html package) can anyone tell me if
Access is able to link the same database to excel, word and intranet sources.

if not is there anything out there that might be more suitable.

Thanks for any help

Matt
 
you can link
you can import

in either case the source could be excel, another access or table of other
type db...

this is all embedded into Access and you can experiment...

Word must be simply structured generally as txt with , delimited

having the data coherently structured is key to successful link or import...

imports are good for occasional or periodic bringing in data - a little
simpler and you can manually manipulate format for a good import......links
are more appropriate for sharing changing data from another working
application but requires maintaining format without variances...
 
Back
Top