Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access import xls data to remote server "speeding up"
Closure :) This is what happened, it went on a halt for some time. I experimented with blob fields a bit(kinda of a bulk insert, just one big one). But then gave up the idea and made a separate program in .net, and that speed things up a bit, since it doesn't have to go through ODBC. Not...- Dolenc090
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access import xls data to remote server "speeding up"
Thank to both of you, will look into SSIS tomorrow and will report back what happened.- Dolenc090
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access import xls data to remote server "speeding up"
Import in access is not really the problem, its quite fast (a few seconds) but when it starts to transfer the data to a table on the server, then all hope is lost :D I also tried transferring the xls(converted to csv) directly to the server file system and then importing. That worked, but to...- Dolenc090
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access import xls data to remote server "speeding up"
Hi, my first topic, so I hope I put it in the right section :). I'm trying to import some data(8 columns, 30k rows) from Excel(xls) file to a db2(iSeries) table trough Access97(uses odbc connection). The server is located in another country and it looks like the connection is a bit slow. For...- Dolenc090
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
