access table from an excel spreadsheet

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

Guest

is it possible to import a spreadsheet into access and then link the access table up to an infopath form...using office 2003... please help
trey
 
is it possible to import a spreadsheet into access and then link the access table up to an infopath form...using office 2003... please help
trey
Click to expand...

May I ask why you felt it necessary to post the same question three
times in under ten minutes? This is a newsgroup, not a chat room; the
volunteers here are pretty quick but you're being a bit demanding!

It's easy to import a spreadsheet into an Access table; open Access
and select File... Get External Data... Import. In the "Files Of Type"
combo select the appropriate version of Excel, then select your .xls
file.

I'm not acquainted with Infopath, but if it can reference JET (.mdb
file) databases you should be able to link to the table that you have
imported.
 
i kept getting an error message on the 1st 2 and i didnt realize they posted.... on the 3rd post it went...sorry my goof...
 
Back
Top