I have been thinking about using some excel data in access. Reading the access help I noticed that it is possible to copy & paste data into access, is this a good way to go? Does excel data import easily and work ok in access?
Excel data
- Thread starter AN60
- Start date
Hi -
Importing data into Access generally works well. Look for "File / Get External Data / Import " in the menus.
Personally, I find some tasks easier to do in Excel and some easier in Access. It is much easier to see what is going in Excel and you don't have to know as much as in Access. There are times when Access offers the ability to summarize and distill data more effectively though.
- g
Importing data into Access generally works well. Look for "File / Get External Data / Import " in the menus.
Personally, I find some tasks easier to do in Excel and some easier in Access. It is much easier to see what is going in Excel and you don't have to know as much as in Access. There are times when Access offers the ability to summarize and distill data more effectively though.
- g
clerics
Registered User.
- Local time
- Today, 17:06
- Joined
- Nov 28, 2005
- Messages
- 82
look in Access help , u'll see this
---> Sub TransferText([TransferType As AcTextTransferType = acImportDelim], [SpecificationName], [TableName], [FileName], [HasFieldNames], [HTMLTableName], [CodePage])
Exam: Enter this code with the right table's name,file's path you can do it easily
DoCmd.TransferText acImportDelim, "", "Winport","c:\documents\abc.xls , True, ""
pm: True--> ignore the fisrt row
---> Sub TransferText([TransferType As AcTextTransferType = acImportDelim], [SpecificationName], [TableName], [FileName], [HasFieldNames], [HTMLTableName], [CodePage])
Exam: Enter this code with the right table's name,file's path you can do it easily
DoCmd.TransferText acImportDelim, "", "Winport","c:\documents\abc.xls , True, ""
pm: True--> ignore the fisrt row
Similar threads
