473,324 Members | 2,268 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

excel2007 active x control

12
HOW DO I LINK MS ACESS 2000 WITH EXCEL-2007 ,,EARLIER I HAV LINKED MS ACESS 200 WITH EXCEL-2000 USING CONTROL "Excel 5.0" ,,what do i do for excel -2007
Feb 21 '08 #1
2 938
debasisdas
8,127 Expert 4TB
Are you facing any problem ?
Feb 21 '08 #2
NEHU
12
Are you facing any problem ?
YES I NOT ABLE TO USE EXCEL 5.0
EARLIER WIT EXCEL 97-03 THIS WORKED BUT NOW ITS NOT


'selecting a particular acess field added to acess from excel
Set dbase = OpenDatabase(excelfile, True, True, "excel 5.0")
sqlquery = "SELECT * INTO [;pwd=nflsl;database=" & acessfile & "]." & acesstable & " FROM [" & worksheet & "$]"
' dbase.Execute sqlquery
Feb 22 '08 #3

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

Similar topics

0
by: Pierre Mengal | last post by:
Active Up is pleased to announce the release of 3 new products. All these products are now part of the Web.Controls Suite . The products featured in the package are: Active Image ..NET...
3
by: Robert Neville | last post by:
How do you return the last Active Control when the control is on a tab control? Screen.ActiveControl does not seem to work. Here's the statement that my code uses. Set ctlOld =...
1
by: Dave | last post by:
Hi, I have an active x control that been createted when i drop it on a win form and sent event to the form event function(like button click event for button control or so), This active x send...
0
by: Kannan | last post by:
My application is an MFC application but since MFC is essentially a Object Oriented wrapper for Win32 I am taking the liberty to post my question here. I also must confess that I am not an Active X...
1
by: Morten Snedker | last post by:
Just for the sake of learning, I'm trying to make a simple Active-X in VB.NET. It should contain the MonthCalendar control, a date should be picked, and the Active-X control would return the...
5
by: Mike | last post by:
I have been using an Active X control(SFrmAx52.ocx) in my Access program without problem in the past. However now I can see the control(SFrmAx52.ocx) in my System 32 folder, I see the control...
4
by: Sarita Sai Bhushan | last post by:
Hi, While I was developing a active desktop web page in ASP.Net using server controls I faced a problem with the autopostback property of server control. The sever control I used in my aspx page...
2
by: Randy | last post by:
I have a form on which various controls are added dynamically depending on actions of the user. One of these actions allows the user to click a delete button that will remove various other...
1
by: JaheerHussain | last post by:
Hi This Is Zahe,Here in my Page is Displayed some Information on TextBox,TextBox property is set Multiline,Information has some fields,but here all information are unformated,my need is, i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.