473,480 Members | 1,515 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Transfer Spreadsheet method in visual basic

5 New Member
hello everyone! i have a problem in coding for my system...i want to know how could i use the
Expand|Select|Wrap|Line Numbers
  1. Const transferDir = "c:\my documents\"
  2. rangeName = "Companies"
  3. tableName = "Companies"
  4. DoCmd.RunSQL "delete from " & tableName
  5. DoCmd.TransferSpreadsheet acImport, 8, tableName, _
  6. transferDir & "OriginalData.xls", True, rangeName 
i want this code to be transferred.. which i will not use SQL as my backend but MS Access....please i need your help guys....thanks
Mar 1 '07 #1
1 2072
willakawill
1,646 Top Contributor
As you are using vba and access, I have moved your question to the access forum
Mar 4 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

13
35470
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
1
2202
by: Neel Word | last post by:
I need to develop an application (development platform: Win2000; target platform: Win98/ME/NT4/2000/XP), which would require file transfer functionality over dial-up and network. We could...
2
2547
by: FrankJeroen | last post by:
Hi there, I have a simple problem, but I can't fix it. I have worked with Visual Basic 6. But I recently switched to Visual Basic ..Net 2003. I have a Form with an Spreadsheet. I want to...
0
1324
by: Dr. Zharkov | last post by:
We have program Visual Basic .NET 2003 for construction of 3D-Graphics as a surface z=f (x, y). From VB .NET 2003 we want to transfer coordinates of this surface as myArrayVB (2000, 1) in myArrayVó...
1
4080
by: Vlad | last post by:
I am trying to decide whether I should buy Visual Basic.NET Standard. I’d like to know the answer to the following questions to help me decide 1. Can I use Visual Basic.NET Standard to create a...
4
6387
by: john andrew | last post by:
-- hello In VB.net can I import an excel spreadsheet into a formand display it. Also edit/save cells also on the form. I want to use code in VB.net form that also effect the spreadsheet....
2
4183
by: Bonzol | last post by:
vb.net 2003 Windows application We have a Client/Server system set up by communicating through a TCPClient object. The server loops continuously using a tcplistener device and each time a client...
0
1588
Frinavale
by: Frinavale | last post by:
Platform: WindowsXP and IIS Language: Asp .NET (using Visual Basic back end) I'm not sure if anyone will be able to understand my code because its written using ASPX and Visual Basic back end. ...
0
5078
by: mix01 | last post by:
Hi, I am trying to get some VBA code working, but am preplex as to why it does not work. I would really appreciate any level of help. Many thanks, Mix01 Version of the program
2
1030
by: aston martin | last post by:
Hello, I am new to this forum and new to Visual Basic. I need someone to point me in the right direction. I have been asked to write a spreadsheet (which I have done) and then use a macro which...
0
7041
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7044
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6739
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
4779
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4481
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2995
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
2984
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1300
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
181
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.