Is it possible to Import EXCEL cell data into Access???

[tireddroopy]

anyone,

I use an Excel Spreadsheet to do my budget report but i want to import the excel data into Access for a transaction record. Is this possible or not? and how? anyone can send me to a link or give me some tips i would be grateful.

Robert

 

[Norie]

It is possible but depends on a number of things.

To get started right click in the Tables tab in Access and select Import. Then navigate to your spreadsheet and double click.

Access should now start up a wizard to guide you through the process.

It should work with no problems if the data in the spreadsheet is organised logically - eg there are column headings, the data in each column is of the same type etc

 

[tireddroopy]

so when i Link the excel in access it will create a table for me.

Will this access table change when excel changes?

Is there a way to send attachment or give you a screenshot of my excel sheet?

 

[Norie]

If you link the Excel spreadsheet then it will be updated.

If you actually import it it won't.

Is there a way to send attachment or give you a screenshot of my excel sheet?

Try this link Colo's HTML Maker