473,383 Members | 1,737 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Transferring specific data between access and excel

20
Hello. I have kind of a ridiculous question, I will explain it the best that I can.

In Access 2010, I have a form with several text controls. There are also two controls that are unbound combo boxes. Upon a new selection being made from these boxes, is it possible to transfer the contents from just these two controls to specific columns in excel so that they may be used in an existing formula?

I'm tempted to think that there is no way to achieve this. If there is, I don't know it. But I don't know everything, so I thought I would ask for other opinions before I tell the client that it's not possible. Thanks!
Aug 15 '19 #1
0 1628

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

Similar topics

0
by: sedefo | last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access...
1
by: Abhijeet Kumar | last post by:
Hello I am exporting data to Excel from my .net Application using ISAM(Jet). I want to delete all record in the sheet before exporting. Since ISAM does not support Delete Operation. I am trying to...
5
by: Jonny | last post by:
Hello, I have created a button on my form which when pressed does the following : 1) Run a pre-defined Macro, which is picking up a query and running my data to excel. However, I need the...
1
by: John E. Fox | last post by:
Some help please! I want to export a line of data to an Excel spreadsheet. Ideally, to insert a new row in a workbook, then add some data from access to specific columns. Any hints would be...
3
by: phong.lee | last post by:
Hello all, i'm new at this. I need some assistant in transferring data from excel to access. I created a macro that basically gather all the necessary data that i need to bring into access. I...
3
by: michb | last post by:
Hi I have decided to export specific data to excel to calculate times and job costing etc and have managed to create a macro to export the data. Can I then adjust the macro to open the excel on...
0
by: D Lester | last post by:
I have recently create membership providers for several diferrent databases which has led me down this path of thought. I need to implement a data access layer for several different databases as...
3
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
I'm confused about Data Access Layer and Data Object Layer. How are they related? Which layer will be affected when the underlying database structure is changed? Which layer will be affect when...
2
by: smita023 | last post by:
Can anybody plz help me me out in getting the Javascript code required for transferring the data from an EXCEL SHEET to NOTEPAD
2
by: mdtam | last post by:
Hi experts, I would like to import data from excel into access. For example I have field "Name" in the excel table. Then I want to import all the data under the field into my database (ms access).
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.