Retrieve Bulk Data From Different Database Into Table

Aug 13, 2011

How can i retrive Bulk Data - from Different database into this database table. At the moment i loop through all the records which is not good idea...i want it to be real quick without linking the table...

I heard something like Insert into statement can work but have never used one....

View Replies


ADVERTISEMENT

HELP! Query Wont Work Now Ive Put Main Bulk Of Data In Database

Oct 23, 2007

Hi all

I am facing disaster after two months of solid work on this database, the deadline is the morning of the 25th and just when i thought i had got it all working i then put the main bulk of the data into the database and the main search query won't work, it freezes and ends with 'invalid argument', when its the same argument as before when there was less data in it. also the relationships window is acting somewhat strangely, i cant seem to move the tables around within it, this is the same for any databases on my computer (im guessing this could be something to do with my Access on my computer)...

A quick note about the search function. it runs three queries dependent on each other, the master query runs of a sub query which runs off an inititial query (this was found to be a very good way of dealing with null values in the database). two of the the tables it runs off is a one to many relationship with the main table so not all contacts will have that variable, but i don't see why this would affect the query. in short the first query in the sequence searches for a status of a contact, then the second uses these results to search for a sub status then the final query searches for publications contacts want from the sub status query. the three tables it runs from are contacts, status(which includes substatus) and publications.

well, it really is the 11th hour here, quarter past the 11th hour to be honest. short of throwing my computer out the window and running off to a tropical island does anyone have any ideas....????

many many many many thanks in advance....

Shapman

View 2 Replies View Related

General :: Possible To Set Up Access Database To Retrieve Data From Control Logix

Nov 21, 2013

Is it possible to set up an access db to retrieve data from a control logix 5000 and put it into a report or form of some sort?

View 1 Replies View Related

Queries :: Retrieve Data From A Table From SQL Query

Feb 21, 2014

How to retrieve data from a table (via query) ? I created the below query, but I'm not sure what else is needed to retrieve the value from my SQL query. My query code is below. I'm not getting any errors.

Dim strClient As String
strClient = "Jerry Davis"
strSQL = " SELECT [Progress Tracking].[Client Name], [Progress Tracking].[Client Start Date],
[Progress Tracking].[Start Body Weight], [Progress Tracking].[Tracking Date]
FROM [Progress Tracking]
WHERE [Progress Tracking].[Client Name])= ' " & strClient & " ' "
MsgBox "Weight Box " & " " & strSQL

View 12 Replies View Related

How To Retrieve Data From A Table And Put It Into Form Field

Mar 9, 2012

I have a table:

And I want to extract the "Submit Date" data and place them into their corresponding fields on a form:

Basically I want to take the Submit Date column from the table and place them (in the same order) in the form. How can I do so? I'm also confused as to what to select for the Control Source in the Form Design.

*Note: both "Submit Date" columns in the form and table are set to Date/Time.

--Using Access 2000

View 1 Replies View Related

Creating A Search Button That Will Retrieve Data From Table And Populate Form

Jan 24, 2015

I've been able to navigate a lot on my own, but there is one issue I cannot seem to resolve. I have 1 form and 1 table. I have the form set up so that you can enter data, and then press a button, and it will "save" and refresh the form for a new entry. However, I want to be able to pull that entry back up in the form, and fill out additional fields later on.The form is set to data entry = yes because I do want the form to open up as brand new each time.

To sum up my question. I want a text box and search button at the top of my form. When you type an ID number in the text box, and then press search, I want access to populate my form with the information in my data table associated with that ID number.

If I type in the number 1234 and hit search. I want my form to autopopulate with the data in the row for ID number 1234 (all the fields I have already populated). So by searching 1234, the name, phone, background info, etc that is populated in the row will appear.

View 5 Replies View Related

Bulk Assigning Of Available Data

Jun 9, 2014

I have a data base of ip addresses. I need to come up with a way to bulk assign Host names to the available ip addresses. The only data that is the same between the two tables is a Farm Name which is the same for each record. My first query creates a temp table that lists ip addresses by farm name that do not have a host name. That is my data pool. Then I import from Excel a list of host names (with farm name) that need ip addresses. What I am not sure how to do is "Combine" the tables. Putting a Host Name with an IP address.

View 1 Replies View Related

Need To Import Bulk In Table With Loop

Mar 22, 2005

Hi, I need help with inputting multiple values in a table
I am using below statement in asp file and it works fine, when I input one value of name in form , as it takes that value and just input into the table. If it already exists then it just displays error message that this name value already exist in table as name field has no duplicate checked. I need to input multiple records now instead of just one.
The current statement I am using is

<%
Name = replace(trim(Request("Name")),"'","''")


SQL = "Insert Into table(tableName) Values('" & Name & "')"

objCon.Execute SQL

%>

But now I want to send multiple values from the text box instead of just one value, so I need a loop here. The values in the text box are separated with enter.
Please let me know how do I run this query in loop that it will input one name first and then input the second value and then third so forth. (input multiple records instead of just one).
Can you please give me the SQL statement for ACCESS or asp querry.

thanks

View 1 Replies View Related

General :: Bulk Email A Report Using Addresses Contained In A Table

Nov 4, 2014

I've a table containing ebay sales information, let's simplify it...

Code:
buyer email product quantity price total Receipt Number
A Smith a.smith@acme.com gloves 1 $10.00 $10.00 1
P Brown p.brown@jones.com hat 2 $15.00 $30.00 2

After a lot of faffing about (& learning about sub reports), I've now got access producing a sales receipt from the data....it's in the form of a report (the report generated is one long continuous report, with each page in the report relating to a sales receipt number)

What I want to do now is email each page of the the report (like I say, each page is essentially an individual sales receipt) to the associated email address in bulk.

Therefore there may be 20 sales receipts in a long continuous report, how would I break them out one by one to a pdf file & send it to the correct email address which is contained against the sales receipt number in the same table?!!!

View 4 Replies View Related

Add Records To Table In Bulk (not One Record At A Time) Via Multidimensional Array

Aug 13, 2015

I'd like to add 600+ records at a time to a table (or at least a lot) and do this 1200 or so times. Yes, this is a very big table, its okay and the size is not an issue.

The key here is that speed is very important. I DO NOT want to AddNew and Update a recordset 700k times (one for each new record). I want to add 600 records or so 1200 or so times.

I am open to any way of doing this in VBA and/or SQL in MS Access; however, I am thinking of building an array that has 600 rows and 16 columns, then somehow add that to the table all at once. I will size the array down if it causes problems. That isn't the issue. The issue is how to add a 2d array to a table in bulk (all at once).

Code:
Sub test()
Dim dbLocal As DAO.Database
Set dbLocal = CurrentDb()
Dim sql As String
'build my array
Dim x(0 To 1, 0 To 1) As Integer

[Code] ....

View 14 Replies View Related

Modules & VBA :: Access 2007 / Code For Bulk Importing TXT File Into Separate Records Same Table?

Jul 9, 2014

I have 12,000 cvs that i need to get into An access database so i can start to extract email info etc. They are stored in one folder All Cvs under each of their names edc.txt (i have converted them to .txt) i want to create one table with two fields name (taken from the cv filename and contents (taken fromthe contents of the .txt file). I am using Access 2007.

View 2 Replies View Related

Queries :: How To Retrieve Only Numeric Data From F1 And Display That Data In A Field

Oct 1, 2013

Background I have a query (Q1) that retrives data from a table (Table 1). One of the fields in Table (F1) contains both text and numeric data (ie: 24 eggs). I want to separate these values in Q1.

Questions
How can i in Q1 retrive only numeric data from F1 and display that data i a field?
How can i in Q1 retrive only text from F1 and display that data i a field?

View 3 Replies View Related

Queries :: Tracking Database - Retrieve Top 100 Records

Jul 24, 2013

I am working on a project where I am creating a database that tracks open orders (old and new orders that still need to be billed but haven't been billed for one reason or another).

I have my "Master" table built and now I need to create 2 queries, one query retrieves the Top 20 orders based on value and that are older then 30 days and the second query is to retrieve the Top 100 orders based on the same criteria but the Top 100 query should not include the orders that appear in the Top 20 query.

My Top 20 query is below

SELECT TOP 20 MASTER.COMBO, MASTER.[Customer Name], MASTER.Status, MASTER.CCD, MASTER.Area, MASTER.[Order Type], MASTER.[Order Value], MASTER.AGE, MASTER.ANALYST, MASTER.COMMENTS
FROM MASTER
WHERE (((MASTER.AGE)>=30))
ORDER BY MASTER.[Order Value] DESC , MASTER.AGE;

I have tried multiple ways to do the Top 100 query and exclude what is returned in my Top 20 query but so far no success.

View 10 Replies View Related

Retrieve Data

Dec 22, 2006

Hi,

I create the table1 in SQL Server and then link the table to MS Access using ODBC. But, when I write do this statement
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("Select * from table1")

for i = 1 to rs.recordcount
msgbox rs.field(0)
next i

It only retrieve 1 record only, but the table have 10 records.
What's wrong with it?
I check rs.recordcount, it only loop one time.

Additionally,
it doesn't work this function in the ODBC link table
rs.addnew
rs.field(0) = "hello"
rs.update

And, when we use ODBC link tables,
we cannot delete data in the table.
currentdb.execute "delete * from table1"

it will give out error message, the table is read-only.

Please let me know about it, thanks.

View 3 Replies View Related

Using SQL In VBA To Retrieve Data?

Aug 24, 2015

i want to retrieve some data from a table i have pieced together a bit of code but get an error to few parameters.

Code:

Dim db As dao.Database
Dim Lrs As dao.Recordset
Dim LSQL As String
Dim Lname As String
'Open connection to current Access database
Set db = CurrentDb()

[code]....

when i paste the SQL into a query it works fine

View 8 Replies View Related

Forms :: Retrieve / Save And Update Data?

Apr 26, 2013

MS Access 2007. I am trying to make a form.

Form2

Text0 = Textfield for ID
Text2 = Textfield for LName
Text3 = Textfield for FName

btnRet = Button for retrieve when ID is entered in Text0
btnUpdate = Button for saving the changes made in the textfields.

How can I search the ID from the Table I made? And when it was matched, get the details of that ID unto the designated text fields. It was like retrieving the data from the table with the ID typed in the text field from the form I made.

Then when it was retrieved, I can edit the fields and when I hit the Update button, the edited fields will replaced the original data.

Also after it was updated, a new record will be added in the history table that the ID was edited. Is is possible?

For now, i want to know how to retrieve the data with the ID and edit and save it after and update the table. Does it applies with the codes with the retrieve button and update button?

View 5 Replies View Related

Modules & VBA :: Retrieve Outlook Data From Access

Feb 6, 2015

It's been some time since I wrote the following, which takes a string made up of "Lastname Firstname Telephone" and writes it at a specific time in Outlook. It uses Late binding so it works across all Oulook versions.

Code:
Public Function funOutputAppointmentToOutlook(dtmDate As Date, strSubject As String)
Dim olApp As Object
Dim mNameSpace As Object
Const olFolderCalendar = 9
Const olAppointmentItem = 1

[Code] ....

I would like to first check the specific Outlook time slot whether the string exists already and only if it does not exist to write it.

View 1 Replies View Related

Queries :: Retrieve Column Name When Data Is Null

Oct 31, 2013

I have a table in which i want a column name as output when the data in it is null.

View 2 Replies View Related

Queries :: How To Retrieve Column Data Using SQL Query

Apr 14, 2014

I'm trying to retrieve data based on the contents of one column.

Sample table

Code:
Description EID Basecode
----------- ---- ---------
ssdad 1001 S2378797
gfd 1002 S1164478
gfdsffsdf 1003 R1165778
ssdad 1004 M0007867
gfd 1005 N7765111
gfdsffsdf 1006 W5464111
gfd 1005 N7765111
gfdsffsdf 1006 A4000011
gfdsffsdf 1006 W5464111
ssdad 1001 2378797
gfd 1002 1164478
ssdad 1001 965000
gfd 1002 780000
yjgk 4456 540000
kjhkh 2009 150000
ddd 1004 1040
d88jg 1004 14C676
fsa 6565 158
fdh 1004 2Khlm
ggdg 2009 967

I'm retrieving all **Basecode** column data starts with only letters other than 'W', 'N' by this query

Code:
SELECT tbl1.EID,tbl1.Description,tabl1.Basecode FROM tbl1 WHERE Not
IsNumeric(Left(Basecode,1)) AND Left(Basecode,1) Not In ("W","N");

And retrieving all **Basecode** if column data length >6 and with numbers '96', '78','54','15' by this query

Code:
SELECT tbl1.EID,tbl1.Description,tabl1.Basecode FROM tbl1
WHERE (((Len([Basecode]))>6)AND ((Left([Basecode],2))='15')) OR
(((Len([Basecode]))>6) AND ((Left([Basecode],2))='54')) OR
(((Len([Basecode]))>6) AND ((Left([Basecode],2))='78')) OR
(((Len([Basecode]))>6) AND ((Left([Basecode],2))='96'));

How do i get other data which won't retrieve based on above queries, other than data mentioned on these queries like this

Code:
Description EID Basecode
----------- ---- ---------

ssdad 1001 2378797
gfd 1002 1164478
ddd 1004 1040
d88jg 1004 14C676
fsa 6565 158
fdh 1004 2Khlm
ggdg 2009 967

Third query not working

Code:
SELECT tbl1.EID,tbl1.Description,tabl1.Basecode FROM tbl1
WHERE (IsNumeric(Left(Basecode,1)) AND Left(Basecode,1) Not In ("W","N"))
AND NOT (((Len([Basecode]))>6)AND ((Left([Basecode],2))='15')) OR
(((Len([Basecode]))>6) AND ((Left([Basecode],2))='54')) OR
(((Len([Basecode]))>6) AND ((Left([Basecode],2))='78')) OR
(((Len([Basecode]))>6) AND ((Left([Basecode],2))='96'));

View 5 Replies View Related

Creating A Query That Will Retrieve Different Data From Different Records?

Mar 17, 2014

I am trying to create a Database that will type our orders. I have a table with our customer list that includes both billing and shipping information. The problem is that sometimes one customer will request a "drop shipment" to another customer. Is it possible to retrieve different data from two different customers? Billing info for customer "A" and shipping info for customer "B" without creating seperate tables?

View 1 Replies View Related

Modules & VBA :: Retrieve Data From Excel And Load It To Query

Aug 12, 2015

Current situation is that I have this form with a chart.

Row Source :

Code:
SELECT PolyWrongRegInsCount.[INSTITUTION], PolyWrongRegInsCount.[NO_OF_GROUP]
FROM PolyWrongRegInsCount;

PolyWrongRegInsCount; <- This table is one of the queries that I created.However, the data is manually added. I want to get the data from excel spreadsheet. And load into my queries

View 2 Replies View Related

Reports :: Combo Boxes - Using Look Up Box To Retrieve Alternate Data

Nov 22, 2013

Is it possible to use combo boxes in reports? I have a report built but was wanting to use a look up box to retrieve alternate data while looking at the report.

View 3 Replies View Related

Retrieve Data From Backend - Update Combo Box From Recordset

Dec 12, 2011

I have written code to retrieve data from a back-end, that is then bound to a form (late binding forms).

From the retrieved record set I want to update a combo box using 1 field from the data in the record set, only showing unique records in the list.

View 5 Replies View Related

Combining Date Columns From Different Tables And Retrieve Data

Aug 17, 2012

I'm trying to retrieve information from 3 tables (Order, Receive and Issue) to one table as Inventory Table/Query. it looks like as follows

Order Table:

OrderID
ProductID
OrderDate
OrderQTY

1
1
3/1/2012
30

2
1
4/1/2012
10

3
2
4/1/2012
20

Receive Table:

ReceiveID
ProductID
ReceiveDate
ReceiveQTY

1
1
3/3/2012
30

2
1
4/3/2012
10

3
2
4/2/2012
15

Issue Table:

IssuedID
ProductID
IssuedDate
IssueQTY

1
1
3/5/2012
20

2
1
4/6/2012
10

3
2
4/5/2012
5

I'm looking for Inventory table/query which will give all of the data per date, which is like the following

Inventory:

Date
ProductID
OrderQTY
ReceiveQTY
IssueQTY

3/1/2012
1
30

3/3/2012
1
30

3/5/2012
1
20

4/1/2012
1
10

4/1/2012
2
20

4/2/2012
2
15

4/3/2012
1
10

4/5/2012
2
5

4/6/2012
1
10

View 3 Replies View Related

Retrieve The Table Names

Jun 28, 2006

Hi:

In the database, I want to create a combox in the form, it the dropdown list show all the table names I created, or linked.

I don't want to create a table to store the table names.

Can we retrieve the table names from the Tables sections directly?

Thanks.

View 1 Replies View Related

Option Group To Retrieve Details From Table

Sep 21, 2005

Hi I wonder if someone could help as I'm relatively new to this. I have tried to search for my answer but I'm not finding stuff that answers my need.

I have 1 table with products (tblProds) and 1 with stocklevels (tblprod_Stocklev). the PLU field is in both tables

tblProds tblprod_stocklev
PLU PLU
Descritption StockLevel_1
CategoryMaster StockLevel_2
CategoryGroup StockLevel_3
Category StockLevel_4 etc....

My query filters using 3 combo boxes using the category fields and the Option group sets its value to the corresponding number in the stocklevel table from a form (1 for stocklevel_1 etc). I have the category filter working as I need (ie selecting all records if left blank)

So to the question: How do I get my query to retrieve only the stocklevels for the required branch? :confused:

Any help/advice is much appreciated :)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved