Threads Replies Last Post 5 Pages: 1  2  3  4  5   populating spreadsheet with data from Access Each semester a coworker needs to repopulate course data into a spreadsheet that contains various calculations. I would like to create a macro/function to pull data from an existing Access database and populate the spreadsheet with data such as course ID (primary key), Instructor name, enrollment count etc. The columns needing updating aren't adjacent to each other. Doing a query via Excel... 4 22.12.2005 00:57:19 Excel Macro Security Settings I have a user who is running using Excel to generate and SQL database query through an ODBC connection. It works GREAT, but .... It requires them to enter the sql password prior to data retrieval even though the user/pw information is embedded in the query. For example, click the button to generate the data and you immediately get a window with sql login info including the correct user id ... 1 21.12.2005 17:48:57 Problem with query when file location changes I have a spreadsheet that contains multiple worksheets. Some of the worksheets query our Navision database and others then query the data retieved from Navision eg. Sheet1 returns data from Navision then Sheet2 queries Sheet1. The problem I have is that if the spreasheet file is saved anywhere other than the location that it was created in or with a different file name then the queries tha... 3 20.12.2005 14:56:59 JET Connection to SAS Hi All, I'm trying to open a JET connection to SAS (a statistical analysis package) from Excel VBA using the code below. **************************************************** Dim wspSAS_Workspace As Workspace Dim dbSAS_Database As Database Dim rcdSAS_Recordset As Recordset Set wspSAS_Workspace = CreateWorkspace("NewJETWorkspace", "admin", "", dbUseJet) Set dbSAS_Databas... 2 19.12.2005 12:44:03 Import data from xls file on the web Can anyone help me with guidelines to import data from web based xls file? Is it possible to import sheet from such file and then update it automatically? Tahnks, Svilen ... 2 13.12.2005 20:43:04 Need some help/advice... My VBA skills are a bit rusty, so I am not sure how to go about this. What I want to do is create an .iqy file that will load a multipage spreadsheet from several different pages. The first page is a summary with a listing of the students and a few other data items. The student's names are links to individual worksheets that contain items specific to them. Is there any way to do this using... 1 13.12.2005 17:55:32 How to run Update query on Access table from Excel VBA Hello, I want to run the following update query in Excel: UPDATE WTMData SET WTMData.HALOT = "myvariable", WTMData.BDB = "myvariable", WTMData.AlternateGloss = "myvariable", WTMData.GlosserInitials = "apb", WTMData.GlossDate = Date() & " " & Time(), WTMData.Parsing = "myvariable" WHERE (((WTMData.HALOT) Is Null) AND ((WTMData.BDB) Is Null) AND ((WTMData.AlternateGloss) Is Null) AND ((... 2 11.12.2005 02:39:02 Cannot get to SQL Query in Excel 2003 I’m using Excel 2003. I’ve been given an Excel file that contains a worksheet with an SQL query. I do not know what the datasource is nor any details about the query itself. When I click on “Edit Query” or “Refresh Data” or “Refresh All”, this error message is always returned “[Microsoft][ODBC Driver Manager] Driver does not support this function” and I am not able to... 2 05.12.2005 08:21:53 [microft] [ODBC Excel Driver] [unknow] it appear the notice: [microft] [ODBC Excel Driver] [unknow] when I refresh the data that I import from an Excel file to another sheet by using MS Query. How could I fix it? Thank you very much for your support. ... 2 03.12.2005 08:10:57 MS Edit and Sql Does anyone know and can you tell me where I can get a list of the SQL commands that work in MS Edit supplied with MSExcel 2000. Thanks Dean -- dkso@ntlworld.com http://www.dkso.co.uk/ http://homepage.ntlworld.com/dkso ... 4 03.12.2005 08:10:56 How to query an excel sheet from an c# method.Specially Date field hello , 1 . i'm triing to retreive buch of row but i want to apply a Where clause, so i get row = a certain date..... but my Query retreive only 1 row always(the first one)...but several should match... i even set the col format to string and still get only 1 row and got no syntax error.. ex: THE SQL PARM LOOKS LIKE : "SELECT F12 AS [Strategy], F5 AS [Quantite], F7 AS [Devise], F2 AS ... 1 01.12.2005 14:35:05 How to copy MS Queries from one cell to many I have created a MS Query that returns a single record's information from an Access Database using a parameter. This parameter comes from a cell in the spreadsheet and is used in the query. For example, cell A1 contains a part number "1234". When I refresh the query, it returns information from the Access db where the part number = "1234". This works well for my single cell/single query.... 3 01.12.2005 12:01:59 Visual Foxpro Driver Hi On one of my machines Visual Foxpro appears as a data source on Microsfot Query - but not on the other. How do I get it to appear? Thanks Max ... 2 29.11.2005 20:33:32 Error Accessing recordset from stored proc Hi there. I'm attempting to use a VB Macro to retrieve a recordset from a SQL Server stored procedure which takes in two parameters - and then paste the results into a worksheet. although I seem to be successful in retrieving the recordset (I can print out the column names OK) - I'm having trouble with the CopyFromRecordSet function. Any suggestions anyone?...... Code below: ... 2 23.11.2005 23:45:17 ADO Recordest.Filter "NOT LIKE" Dear colleagues, Is there any way to filter ADO Recordest using criteria "[SomeColumn] NOT LIKE 'SomeExpresion'". I don't mean "NOT LIKE" criteria within SQL statement used in Recordset.Open(that's work correctly), but in context Recordset.Filter = "[SomeColumn] NOT LIKE 'SomeExpresion'". Wider context: I need to obtain the index(-es) - row position value(-s) of row(-s) within some data ta... 1 20.11.2005 15:01:03 Query Wizard - filter data to match value in spreadsheet cell I have a spreadsheet that contains a drop-down list with values. When the user selects a value I want to get external data from a Perforce (scource code control) database. In the 'Filter data' in the query wizard I'd like to specify the value selected by the user in the spreadsheet but I don't know how to do that. Getting the external data works if I specify a value to filter by, but ... 4 16.11.2005 13:28:58 How to import a table on a Web page to Excel? Hello How to import a table on a Web page to Excel? Columns in the table are delimited by several spaces, not by a htm table tag. ... 9 11.11.2005 10:26:30 SQL Server Connection String fro Stored Procedure I have Excel 2003. I am trying to run a code to connect to an ODBC and run a stored procedure. I can not connect. Please help. The code looks something like: Sub SetTrigger_LOCK_Reports() Dim db1 As QueryTable DBName = "MY_Reports" sqlstring = "MY_Reports.dbo.spSetReportLinkAvailability (@isActive = 0,@message = 'Current reports are being processed at this time.)" myUID = "ItsMe" m... 1 10.11.2005 00:32:36 canadian women 62% of canadian women have done this.What is it?... 1 09.11.2005 20:10:38 Problem with DTS reading from spreadsheet Has anyone encountered an issue with blank cells when DTS tries to read a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I have a spreadsheet where I read a range, and some of the cells show up as blank even though there are values in them. If I alter the cell and resave the sheet, it works fine. I suppose this could be worksheet corruption, but I wanted to see... 3 09.11.2005 14:42:17 From SQLite to Excel with ODBC Hello, I would like to access from Excel 2003 (OS: Windows XP) to a SQLite-Database with ODBC. I did the following steps: 1.) Install SQLite-ODBC-driver: From http://www.ch-werner.de/sqliteodbc/ I downloaded the file "sqliteodbc.exe" which installs the ODBC-driver on my computer. I saw after the installation on the "ODBC-datasources/System-DSN"-menu three new entr... 1 03.11.2005 18:27:54 5 Pages: 1  2  3  4  5