<div>
We need the databse name and what version of access and create a connection to the database and write the data. To have something precise can you post 
sample of the excel that has the data the way you have it. 
The database to which you want to import. 
 
Gowflow
</div>

<div>
sorry, The column name in the excel file &nbsp;is &nbsp;&quot;Sales_Value&quot; 
 
The field name in the access table is also &nbsp;&quot;Sales_Value&quot; 
Database name is &nbsp;&quot;MyDatabase&quot;
</div>

Data Engineer

Fordraiders

<div>
<pre><code class="code-10 nolinks" id="code-20-43078729-1"> Dim adoConn As adodb.Connection
 Dim adoRS As adodb.Recordset
 Dim sConn As String
 dim adoAdd as adodb.Recordset
 
 Set adoConn = New adodb.Connection
 sConn = &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; &amp; _
 &quot;Data Source=\\us.xxxxxx.com\files\Office\MK\sales support\Rebates_Import\Rebate_Sales_Adj_Terms_LOV.xlsx&quot;;Extended Properties='Excel 14.0;HDR=1'&quot;
 adoConn.Open sConn
 
 Set adoRS = New adodb.Recordset
 Set adoAdd = New adodb.Recordset

 adoRS.Open &quot;SELECT * FROM [dbo_Rebate_Sales_Adj_Terms_LOV]&quot;, adoConn
 adoAdd.Open &quot;Rebate_Sales_Adj_Terms_Import_Tbl&quot;, currentproject.connection

 Do While adoRS.EOF = False

 Currentdb.execute &quot;insert into Rebate_Sales_Adj_Terms_Import_Tbl (Sales_Value) SELECT Sales_Value from tblXL&quot;


 Debug.Print adoRS.Fields(0).Value

 'Add record
 adoAdd!Sales_Value = adoRS.Fields(0)
 adoAdd.Update
 adoRS.MoveNext
 Loop
 adoAdd.Close
 Set adoAdd = Nothing
 adoRS.Close
 Set adoRS = Nothing
 adoConn.Close
 Set adoConn = Nothing
</code></pre>
 
 
this is way i was trying to do it in OLD 32 bit &nbsp;?
</div>

<div>
ET ALL,,,, 
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, _ 
&nbsp;&quot;Rebate_Sales_Adj_Terms_Import_Tbl&quot;, &quot;\\us.XXXXX.com\files\Office\MK\sales support\Rebates_Import\Rebate_Sales_Adj_Terms_LOV.xlsx&quot;, True 
 
 
This worked ok, but i guess there is no way to map fields...if i needed them to. in case of bad syntax ? 
 
fordraiders
</div>

<div>
If you want something extra then the only solution is Excel Automation...you treat Excel as object..you open the spreadsheet and you iterate it by Cell...probably you save them to a temp table.examine the values to see if they match what you expect/want and accordingly you act. 
</div>

<div>
i was looking for mapping.... johns code does that for me. 
</div>

<div>
<div class="content wysiwyg-content">
vba code to import data from a shared drive to an access table 
 
No Linked worksheets. 
 
I need to import excel worksheet from a network drive 
and then append to a access table. 
 
 
cant use saved import or a Linked table. 
 
&nbsp; Set appExcel = CreateObject(&quot;Excel.Application&quot;) 
&nbsp; Set myWorkbook = appExcel.Workbooks.Open(&quot;\\us.xxxx.com\files\Office\NB\MK\sales support\Rebates_Import\Qualifier_Entity_LOV.xlsx&quot;) 
 
Sheet &nbsp;Name &nbsp;= &nbsp;&quot;Sales_Adj_Terms_LOV&quot; 
 
Access table to append to = &quot;tbl_Import_Qualifier&quot; 
 
 
 
 
 
Thanks 
fordraiders
</div>
</div>

vba code to import data from a shared drive to an access table

No Linked worksheets.

I need to import excel worksheet from a network drive 
and then append to a access table.


cant use saved import or a Linked table.

  Set appExcel = CreateObject("Excel.Application")
  Set myWorkbook = appExcel.Workbooks.Open("\\us.xxxx.com\files\Office\NB\MK\sales support\Rebates_Import\Qualifier_Entity_LOV.xlsx")

Sheet  Name  =  "Sales_Adj_Terms_LOV"

Access table to append to = "tbl_Import_Qualifier"





Thanks
fordraiders

vba code to import data from a shared drive to an access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.