Kindly help me how to upload a bulk of data in ms access.
In table1 i am having only ReferenceNo's.
In table2 iam having ReferenceNo's,N ame,Place,Area.
I have to upload the Bulk data of the table2 against the referenceNo in table1.
Kindly help me.
Ananth
7 6671 NeoPa 32,569
Recognized Expert Moderator MVP
I'm afraid your question is not very clear, if indeed it is a question.
What is it you're struggling with?
Give an illustration maybe so that we can grasp what you're talking about.
I'm afraid your question is not very clear, if indeed it is a question.
What is it you're struggling with?
Give an illustration maybe so that we can grasp what you're talking about.
I want to bulk upload a excel sheet data to access table.
In Access table fields contains of Claim No, Status.
I want to upload the excel data match against the Claim No is Access Table.
NeoPa 32,569
Recognized Expert Moderator MVP
No illustration, and still not much sense in the explanation.
I'm sorry, but I can't help you until I have some sort of idea what you're struggling with.
What do you mean by Bulk Upload?
If it has to be uploaded and processed according to existing data in a current Access table, then how about explaining that?
If your response to a request for clarification is simply to add a couple of words to your original, then I can see we will struggle to make progress.
In Excel (sheet1) I am having "CLAIM_NO" and "STATUS" column - ----------------------------------
-
CLAIM_NO | STATUS
-
----------------------------------
-
1 | Approved
-
---------------------------------
In Access table (tblCustomers) I am having "CLAIM_NO" and "STATUS" - ----------------------------------
-
CLAIM_NO | STATUS
-
----------------------------------
-
1 | (blank)
-
---------------------------------
Against the Claim No in MS ACCESS table I want to update the "STATUS"
There are arround 100nos of STATUS in MS Excel where I have to upload into MS Access against the CLAIM_NO.
Kindly help me
NeoPa 32,569
Recognized Expert Moderator MVP
Thank you. I think I see your problem now.
The solution is a two step one. - Load the Excel data into Access.
- When the data is available in Access (from Excel) then use this data to update the original Access table data.
In more detail then, Step A can be done in either of two ways : - Link the Excel worksheet into your Access database using an Excel link. This allows the data in an Excel worksheet to be treated AS IF it were in an Access table.
- Import the Excel data into an existing or new Access table.
Let me know if this makes sense to you. If so, are all the steps ones you feel confident in handling yourself, or may you need some further assistance?
I have imported the data to an new access table. tblApplicants contains - --------------------------------------------------
-
ClaimNo | Status
-
-------------------------------------------------
-
10520 | (blank)
-
20489 | (blank)
-
35621 | (blank)
tblClaim contains - ---------------------------------------------------
-
ClaimNo | Status
-
----------------------------------------------------
-
10520 | Approved
-
20489 | Rejected
-
35621 | Pending
I Want to update the tblApplicants "STATUS" from tblClaim "STATUS" against the ClaimNo.
Kindly get me the SQL or VB Code for the same.
Kindly help me. I am a Beginner in Ms Access.
NeoPa 32,569
Recognized Expert Moderator MVP
Let's start with some basic instructions. You seemed to get on quite well with the earlier ones. If we need to get into more detail later then we can. - Create a query (using the wizard) based on [tblApplicants].
- Add the other ([tblClaim]) table in.
- Link the two tables together on [ClaimNo].
- Convert the type of query to an Update query.
- Add the field tblApplicants.S tatus and enter tblClaim.Status into the Update to position.
- Save the query.
If you like you can then post the SQL from this query in here & I will check you have it perfect.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: jason |
last post by:
What are the technical challenges in getting a local SMTP email server set
up on a win3k system or alternatively on a win2k pro local work statation.
We are on the verge of acquiring a new win3k system for local asp testing
development purposes and to allow satellite branches to ftp-in and grab
images.
I need to utilize the bulk emailing facility to send up to 20,000 emails a
day after looping through my customer list which resides in...
|
by: iqbal |
last post by:
Hi all,
We have an application through which we are bulk inserting rows into a
view. The definition of the view is such that it selects columns from
a table on a remote server. I have added the servers using
sp_addlinkedserver on both database servers.
When I call the Commit API of oledb I get the following error:
Error state: 1, Severity: 19, Server: TST-PROC22, Line#: 1, msg:
|
by: Azkaban |
last post by:
Hi, are there someone who know what kind of control or component Share Point
Portal Server use to make bulk upload documents?
Thanks.
--
---------------------------------
Filippo Macchi
www.filippomacchi.it
|
by: ABC |
last post by:
Our environment has two servers, one is web and another is SQL Server. I
can write upload file to IIS. But, I cannot call SQL Server's BULK Insert
statement.
Is there any idea to handle this case?
|
by: Sandeep Singh Sekhon |
last post by:
Hi
I am developing an application in ASP.NET 1.1. In this application, I
want to import the data in bulk from XML Files to the Database. The
problem is that I want to upload only those nodes which don't have
errors in it. Rest of the nodes I want to show to the user so that he
can correct them and upload to the database. How can I do this?
I m using XmlDocument to separate the nodes having errors but I am not
able to remove the nodes...
| |
by: Sumanth |
last post by:
Hi,
I am running into a problem ( only in this particular instance).
I insert one row into a table - takes a fraction of a second
try to do a bulk load of the same --takes 10 seconds.
Anything that I need to be looking into to identify why bulk load
takes a long time?
|
by: RedMoosh |
last post by:
is it possible to rn a client side vbscript to send messages using
cdo.message and cdo.configuration? what are the requirements to do this? my
wks are xp and 2000 and all have cdosys.dll registered. do i have to have
outlook express loaded. i have workstations that don't have outlook but
rather lotus notes and want to send email to an smtp server. these emails
have local attachment thus the need to run client script versus server...
|
by: Jason |
last post by:
Hi
I wanted to bounce an Idea off you guys. I'm not sure if it's possible
or even how to implement it .. or possibly if I'm trying to re-invent
the wheel.
Our users currently use excel and a file upload feature through an
asp.net intranet ap to bulk insert data into our databases - the
function works fine provided the file does not have format issues. The
process also requires some knowledge of excel and that users don't get
|
by: Tim Satterwhite |
last post by:
Hi All,
I think this is a thorny problem, and I'm hoping you can help. I've not
found this exact issue described anywhere yet.
I have a stored procedure that calls BULK INSERT on a set of text files.
These files are FTP'd from a legacy system (a mainframe running MVS).
Sometimes, the process steps on iteslf, whereby the bulk insert is attempted
on a file whose FTP is still in progress; it's not fully written to disk on
the SQL box...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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 we have to send another system
| |