How i can use Excel With Access?

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

Guest

hi

i have 4 Excel sheet i want to put them in one form

is there is a way to do that?

& do i'm going to use VBA

thanks for any help
 
What do you mean, you want to put Excel spreadsheets in a form in Access?
You want the user to be able to see them? Or do you want them to be able to
edit the data? What advantage are you going to gain from putting an Excel
spreadsheet into an Access form, as opposed to simply working them in
Access? Why not import the data into Access and then delete the Excel
sheets?

Access and Excel are two very different animals. Excel works very well for
spreadsheets, Access does not. Access works very well for relational
databases, Excel does not. If you have a spreadsheet (and plan to keep it a
spreadsheet) then you should not use Access for your task.

Lots of more information needed before we can really help you out.
 
Back
Top