How to transfer data from excel to Access?

[mit]

Hi,


I was wondering if any one can help me find a way to transfer data from excel to Access.
I have a CSV file which is opened by Excel.I do not know how to start.

Thanks

[Bob Fitz]

There is a wizard in Access for importing data that should do most of this for you.

click File on main menu.
click Get External Data.
click Import
Select the file and file type

I think you will be able to handle it yourself from then.

[mit]

I have created a database in Access with one CSV file(by transfering data from excel to Access),it works,but I have 52 CSV files and I need to transfer the data(of 52 files) to one Access database.

[Bob Fitz]

I have created a database in Access with one CSV file(by transfering data from excel to Access),it works,but I have 52 CSV files and I need to transfer the data(of 52 files) to one Access database.

Into one DB but into just one table or into 52 tables?

Instead of importing each file manually, you could write some code to use the "TransferSpreadsheet Action". (see Access help files for more info on using this)

Do you actually need to import this data? Access can be linked to data in an excel file.

[mit]

Into one DB and into 52 tables.
actually I am new in Access and I do not know how and where to write code in Access.

[Bob Fitz]

A db that needs 52 tables sounds like a large project for someone who is new to access.