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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Excel, assign cells in multiple worksheets from one sheet 1
Need to create database that is only accessed through a form. 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Importing any excel files with any sheet name into different tables in MSAccess using code 0
make bold partial text in a concatenated control (with RTF2 maybe?) 0
Access #Error & Excel Pivot 0
Browse button for access form 1

Back
Top