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
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
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.![]()
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
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?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.
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.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
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.
A db that needs 52 tables sounds like a large project for someone who is new to access.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick