473,704 Members | 3,112 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Microsoft Access Table / Query Export

1 New Member
I have 2 tables' tblRHM and tblRHM1. tblRHM has suploc, penloc, and RHM. tblRHM1 has RHM1, suploc, penloc, fname, lname, mname, dob, address, b1, b2, b3, and uniqueID . I also have a template I would like to use. The template has fname, lname, mname, dob, address, b1, b2, b3, and uniqueID. I would like to export fname, lname, mname, dob, address, b1, b2, b3, and uniqueID from tblRHM1 to my template. In tblRHM1 each individual is part of a RHM and I would like to export each group of RHMs into a separate spreadsheet (template). tblRHM is more of a crosswalk.
Feb 16 '15 #1
1 1169
3,653 Recognized Expert Moderator Specialist

I am not sure i understand what you are asking or trying to do. It looks like you have a lot of duplicated data, and are trying to duplicate it even more? Is your "template" also a Table?

Your request is not very clear.
Feb 19 '15 #2

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

Similar topics

by: JJ | last post by:
Hi, usually, I'm not using MS servers, but I have a big problem with a Access table. I should create a web application for a Historical Dipartment. They have created a populated a Access database using unicode compression field (for ancient language). I would like to export this table into MySQL o Postgres, but it's
by: Keon | last post by:
Hoi, I'm using a database with alot of records in 1 table (more than 3000). If i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code: StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved
by: premmehrotra | last post by:
I am using Microsoft Access 2000 and Oracle on Windows 2000. When I export a table from Access to Oracle using ODBC I get error: ORA 972 identifier too long I think the error is because one or more columns in Access table are longer than 30 characters. My question is how one can overcome this problem. I also see several column names which have /, ? or spaces in name
by: Michael SL | last post by:
I am trying to get the Table Column definitions from a Microsoft Access 2000 database (*.mdb). Using VB with System.Windows.Forms.Form I do the following Dim OpenDBDialog As New OpenFileDialo OpenDBDialog.Filter = "Database files (*.mdb)|*.mdb OpenDBDialog.RestoreDirectory = Tru If OpenDBDialog.ShowDialog() = DialogResult.OK The Dim ColumnName As Strin Dim ii As Intege Dim jj As Intege Dim oConn As OleDbConnectio
by: jalmar | last post by:
Hello....I'm back again with the same question. I still haven't been able to figure out why my query isn't working. I am linking a table to an Excel spreadsheet, that part is fine, it is even updating correctly (when I update in Excel, the Access table is updated) my problem is when I query out the information that I need from this table-it creates far too many records. I asked this question before and was asked for the SQL but couldn't find...
by: Lefke123 | last post by:
hello, does anyone know how to write certain information from a table / query using VB into a new excel sheet for example; i press a button and a printable excel file is made with the name "random .xls", including 2 sheets, both with different strings of text id only need the basic codes for it, if anyone knows them?
by: chicane | last post by:
I am currently writing a query in Access. I need to set up a parameter query for three fields which are called Status (text field), Authorised (date field) and Legal notices (date field). I need to set it up so that the user can enter info into each of the fields and run the query from that but I also need to set it up so that if nothing is entered into the parameter boxes that it needs to return all results. I have set up the first...
by: Angelia Howard | last post by:
There is no way to narrow down the data with queries. I would like to have the vb code to split up an access table into tables of no more than 50000 each to be able to export to excel. The export has to be excel.
by: Ben Cherry | last post by:
Hi I have created a tablein acess 07 with three fields; admno, name, and Mark/100. My problem is that i need to have a field with position of this students based on the marks i.e the one with highest mark be position 1 and the one with least marks to be the last. i hope to rank those which tie in marks as well. Kindly help example. Table Name is "Students Marks" Admno Name marks 1200 Jane 56
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
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: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
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: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
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: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.