Hi All,
I have a requirement to upload specific range of excel data to sql server table using MS Access. Any one have any idea, how to do this using ms access?
Regards,
Selvakumar R
Hi All,
I have a requirement to upload specific range of excel data to sql server table using MS Access. Any one have any idea, how to do this using ms access?
Regards,
Selvakumar R
TransferSpreadsheet method allows specifying a range for import. I don't use SQL database but if Access is linked to the table then think should be able to import into it.
Other VBA methods require opening the Excel file as an object then reading in one cell at a time by using looping code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Presuming the SQL Server table is linked, look at TransferSpreadsheet in Access help. It allows a range to be specified.
Thanks June7 and pbaldy. In Access I linked my sql server table. I will try using TransferSpreadsheet method in Access and let update the status.