using excel to enter data

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

Guest

Hi,

Is it possible to use access as a means for users to enter data into an
access database? And if it is, can anyone reccomend any good sites where I
can find out how to do this?

Thanks,
Chris
 
Why not just use Access anyway? I am not trying to convert you. It depends
what your intentions are.
 
I think what you meant to ask is "Can people enter data in Excel, and then
have that data available to Access?"

If this is so, the answer is Yes. Depending on your needs it could be as
simple as creating a 'linked' table in Access pointing to the Excel
spreadsheet. This would be done via 'Get External Data'
 
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

Using SQL server as a backend 2
Can I publish an Access Page in SharePoint and enter data? 2
CAN'T ENTER DATA TO THE DATABASE 3
Can I embed and link an Access Form into a SharePoint page? 1
enter data in access 12
Access #Error & Excel Pivot 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
data entry using 2k7 not viewable in 2k7 but is viewable in 2k3 1

Back
Top