How do I get a Access Form to work in excell, but transfer data to Acess?

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I built a workbook in Excell, But I would like to build our customer
base in Access. The problem is I have a sheet in excell for collecting
data on customers, Can I merge a Form into that sheet or does it have to
be totally seperate.
 
I would do it all in one or the other. Getting the two to work together is
not trivial.
However, you can import Excel data to Access or export Access data to Excel
fairly easily.

Dorian
 
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

How do I invoice a cost to a custom built MS Access Accounting Database? 0
Single Excel Cell to Access Form 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0
Excel How to extract the data from Excel . 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting Data from Access To Excel 10
Macro to copy value in field and insert it into filter 2

Back
Top