0

I have search all over internet but can't find the way to export an access table as Excel file in vb.net

Anish choudhary
  • 19
  • 1
  • 7
  • Can you get the Access table into a `DataTable` ? That would be a good place to start. – Andrew Mortimer Jan 21 '16 at 15:09
  • Your search skills need work: http://stackoverflow.com/q/6854750/1070452 among 70,000 others – Ňɏssa Pøngjǣrdenlarp Jan 21 '16 at 15:12
  • This one too. It's C# but it's very handy - http://stackoverflow.com/questions/20496952/programmatically-export-query-table-from-ms-access-to-excel-using-c-sharp – Fᴀʀʜᴀɴ Aɴᴀᴍ Jan 21 '16 at 15:12
  • You could create a DataAdapter, setup a SQL INSERT statement with parameters coupled with a SQL SELECT statement. Load data from msaccess via the adapter then loop through the underlying data table and perform inserts. I have a working conceptual example on Microsoft One Drive to see what I am talking about https://onedrive.live.com/redir?resid=A3D5A9A9A28080D1!887&authkey=!AFT5GkDGDcUT7uI&ithint=file%2czip – Karen Payne Jan 21 '16 at 15:27

0 Answers0