No announcements
Found 3176469 threads
-
0 VotesInsert In two tables in one go.
Hi I am using ADO.net 2.0 and Access 2000.Answered | 1 Replies | 3393 Views | Created by Nvdeep - Wednesday, April 2, 2008 4:31 AM | Last reply by Sukanya Srinivasan - Thursday, March 26, 2009 2:29 AM
-
0 Votes
Recordset Destination to SQL table?
In my database there are two separate tables (Table A and TAble B) that I need to split that data from that one Excel file and load into the correct ...Answered | 9 Replies | 9511 Views | Created by Dave Oh - Thursday, August 16, 2012 5:06 PM | Last reply by Dave Oh - Thursday, August 23, 2012 7:27 PM -
0 Votes
trying to open a linked table.... what's going on?
The problem was trying to OpenTable and do Seek method on a linked table and ACCESS wasnt having it.Answered | 12 Replies | 11810 Views | Created by ADG144 - Monday, May 6, 2013 7:02 PM | Last reply by ADG144 - Tuesday, May 7, 2013 9:22 PM -
2 Votes
This recordset is not updatable - Access 2010 with linked tables from SQL Server 2008
Dirk, I have been reading through your post again trying to understand how I can get Access to save every field on the form in the Result table instead of ...Answered | 15 Replies | 15764 Views | Created by RSNoobie - Friday, January 18, 2013 3:50 PM | Last reply by RSNoobie - Wednesday, February 20, 2013 4:14 PM -
1 Votes
Recordset to Word as a Table
Hi NoviceVBAuser, It denpends on how many rows you want to insert.Answered | 8 Replies | 1863 Views | Created by NoviceVBAuser1775 - Thursday, May 24, 2018 8:01 PM | Last reply by Edward8520 - Monday, June 11, 2018 1:50 AM -
0 Votes
Run an Insert for each recordset iteration
I would completely disagree with you on that one along with other MS Access MVPs.Answered | 22 Replies | 2548 Views | Created by DanHaf - Wednesday, March 5, 2014 7:02 PM | Last reply by Naomi N - Tuesday, March 11, 2014 6:11 PM -
1 Votes
Trying to insert recordset into Access table in one go
So, if you're able to create a recordset object filled with data you pulled from SQL Server using a Stored Procedure, one way to populate your Access table is to ...Answered | 7 Replies | 310 Views | Created by ryguy72 - Wednesday, April 18, 2018 5:34 PM | Last reply by .theDBguy - Wednesday, April 18, 2018 8:32 PM -
3 Votes
ACCESS 2007: Using VBA to export a table or recordset into Excel 2007
In Access 2007 you can go to the External Data ribbon, then in the Export group you can click Excel, then go through the options and export a table into excel ...Answered | 9 Replies | 53465 Views | Created by KyssMe143 - Wednesday, February 2, 2011 8:40 PM | Last reply by ryguy72 - Sunday, September 29, 2013 10:01 AM -
0 Votes
VBA INSERT INTO converts text recordset into integer problem
This encloses the value in single quotes, forcing Access to interpret it as a text value.Answered | 2 Replies | 626 Views | Created by icyrius - Thursday, April 7, 2016 7:03 PM | Last reply by icyrius - Thursday, April 7, 2016 7:18 PM -
4 Votes
Set index on recordset
On the other hand, if you do multiple insert trough VBA and recordsets, you could see that inserting trough recordset become perceptibly slower ...Answered | 19 Replies | 4943 Views | Created by xps350 - Thursday, August 18, 2011 10:31 AM | Last reply by Andrey Artemyev - Thursday, August 18, 2011 5:32 PM -
4 Votes
Define Query Field As A Recordset
This is one of the reasons they invented LINQ for the .Net languages.Answered | 9 Replies | 3035 Views | Created by Lawrence Ellefson - Thursday, July 5, 2012 7:09 PM | Last reply by Joshua Honig - Friday, July 6, 2012 12:49 AM -
0 Votes
Inserting Data into two tables one by one
You are trying to fake pointer chains with a count of the physical insertion attempts and nto use a real key.Answered | 4 Replies | 3292 Views | Created by dathy - Thursday, July 5, 2012 9:02 PM | Last reply by Erland Sommarskog - Friday, July 6, 2012 9:17 AM -
0 Votes
Recordset Destination
OK, I wasn't clear that you were storing it in a recordset.Answered | 5 Replies | 4594 Views | Created by Shailesh_das - Monday, April 6, 2009 8:20 AM | Last reply by jwelch - Monday, April 6, 2009 3:47 PM -
0 Votes
Merge Access Tables into ONE Table
Microsoft Access MVPAnswered | 5 Replies | 1670 Views | Created by Joe Marx's - Thursday, June 13, 2013 1:04 PM | Last reply by Tom van Stiphout (MVP) - Thursday, June 13, 2013 1:36 PM -
0 Votes
Insert image (image data) in Access Table
Hans, I'll give this a try and report back.Answered | 7 Replies | 1078 Views | Created by Greg Maxey - Saturday, August 15, 2015 4:41 PM | Last reply by Hans Vogelaar MVP - Sunday, August 16, 2015 2:02 PM -
0 Votes
Compute recordset averages and insert results into another table
Try INSERT INTO Bar ([order], SoilName, Hydgrp, [percent], slope) SELECT [order], SoilName +CAST(Distinct SoilName) AS VARCHAR(10)) as ...Answered | 6 Replies | 3490 Views | Created by deskcheck1 - Monday, May 3, 2010 3:21 PM | Last reply by deskcheck1 - Monday, May 3, 2010 8:14 PM -
0 Votes
Problem with automation access recordset object in outlook
It returns a recordset but it has no pointer50% of programming is coding.Answered | 11 Replies | 992 Views | Created by JonWayn - Sunday, July 31, 2016 12:38 AM | Last reply by JonWayn - Monday, August 1, 2016 6:48 AM -
0 Votes
foreach loop - insert record in table
If you're looking for a temporary spot to place your recordset, use a temp table in SQL or a RAW file.Answered | 4 Replies | 6002 Views | Created by Parry2k - Friday, October 22, 2010 10:34 PM | Last reply by Todd McDermid - Friday, October 22, 2010 11:27 PM -
0 Votes
TableMapping in DataSet compared with ADO recordset
OP are you looking for the .NET equivalent of an ADO recordset or are you trying to actually use an ADO recordset (perhaps returned from a COM object) in .NET?Answered | 4 Replies | 3098 Views | Created by learner08 - Monday, July 27, 2009 12:46 PM | Last reply by CoolDadTx - Wednesday, July 29, 2009 1:25 PM -
1 Votes
Reading Stored Procedure Recordsets
OPENQUERY (and similar) and INSERT EXEC can be used to make stored procedure output table like.Answered | 12 Replies | 17660 Views | Created by Ali Haghighat dana - Saturday, January 2, 2010 4:16 AM | Last reply by Crakdkorn - Thursday, September 27, 2012 3:00 PM - Items 1 to 20 of 3176469 Next ›
No announcements
