Recent content by NewbieA
-
N
Import from CSV to a SQL table on a remote server using VBA Access
HI I used the bulk insert statement on SSMS to see if it works.- NewbieA
- Post #3
- Forum: Modules & VBA
-
N
Import from CSV to a SQL table on a remote server using VBA Access
Hello All, We are migrating to Access 2013 from 2010 and from SQL 2008 to 2016. To import a CSV file, I used the Docmd.TransferText command and that did the import easily as it was to a local access table. Now I have issues when trying to import the data from CSV to a remote SQL table. I...- NewbieA
- Thread
- Replies: 3
- Forum: Modules & VBA