All geek questions in one place

Import Excel data programmatically to access a table with a column view

I'm looking for a / VBA tool code snippet that can transfer my excel data to my access table with efficient column mapping. Someone please share if you have ideas on these issues.

Thanks in advance

+3
source share
3 answers

The standard way to import or link Excel in Access is to use the TransferSpreadsheet method of the DoCmd object . Link to 2007, but it has been available since 2000, if not earlier. TransferSpreadsheet contains an argument HasFieldNames.

+3
source

In Access 2007 you can use External date/Import/Excel

, , , . , .

Access 2003 File/Get External Data/Import File/Get External Data/Link tables .xls

+2

If this task is what you need to do on a regular basis, you might want to create a macro and a scheduled task to do it automatically. it is very easy to install and I can outline the procedure if necessary

0
source

Source: https://habr.com/ru/post/1793789/

More articles:


All Articles