I have an Access 2003 table that I want to generate into tabbed Excel
2003 workbooks using a button on a form.
The tables would need to overwrite everytime that the button would be
pressed.
Table name: Datatable (data)
Field1: Customer (Bob, Dan, Joe)
Field2: Model (Ace, Cat, San)
Field3: YrMo (2007-01, 2007-02, 2007-03)
What I need is to get them into this format:
Workbook: Bob-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Bob-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Bob-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Dan-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Dan-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Dan-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Joe-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Joe-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Joe-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
I've tried several methods so far, and I just can't seem to get it
right.
Anyone with some pointers/code?
2  1822 
On Oct 8, 2:29 pm, mwillia...@soca l.rr.com wrote:
I have an Access 2003 table that I want to generate into tabbed Excel
2003 workbooks using a button on a form.
The tables would need to overwrite everytime that the button would be
pressed.
Table name: Datatable (data)
Field1: Customer (Bob, Dan, Joe)
Field2: Model (Ace, Cat, San)
Field3: YrMo (2007-01, 2007-02, 2007-03)
What I need is to get them into this format:
Workbook: Bob-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Bob-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Bob-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Dan-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Dan-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Dan-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Joe-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Joe-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
Workbook: Joe-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
I've tried several methods so far, and I just can't seem to get it
right.
Anyone with some pointers/code?
The TransferSpreads heet( ) function can do most of this, if not all.
I have tried using that but I can't get it to do the tabs portion.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ilan |
last post by:
Hi all
I need to add data from two Excel sheets (both on the same workbook)
to an existing table in my SQL DB.
The problem is that each sheet holds different fields for the same
record, though the records are sorted by row numbers.
(I had to split the fields to different sheets because Excel has a
limit of 256 fields in each sheet)
My sheets are quite large (~55,000 rows and 200 columns each) and I'll
have to repeat this action many...
|
by: Jason H |
last post by:
Okay, here is my problem and understand I have little experience with
Access.
I am trying to integrate 3 spreadsheets into Access. Each spread
sheet is about 50 legal pages in size and are linked by a persons
name. What I need is a way to do this enormous task.
Here is an idea of what I have, Spreadsheet 1 looks like;
A1 B1
|
by: PrinStation |
last post by:
I am looking to import data from Excel to Access. The data is set up in one
Excel file, but on 12 (monthly) sheets. After importing the first month/sheet
(which I did successfully), I was looking to use the old dBase 3 plus command
"append" to bring in the eleven remaining sheets. I am thus far unable to find
"append" or rather its Access equivalant. What to do? Any help is appreciated.
|
by: Gary Wright |
last post by:
I have an Access 2K database split into front and back. Quite often the
users want to do some data analysis that I have not created a report for so
they want to export some subset of the data into and Excel spreadsheet.
Since the data often comes from many different tables, I have decided to
create a temporary Access table, put all the data into it then use the
Docmd.TransferSpreadsheet command to output the table to a spreadsheet.
In...
|
by: Arno R |
last post by:
Hi all,
I will have to handle a lot of really 'nice' data in a LOT of Excel sheets. It is all about music files (Billboard top 100)
I am afraid there really is a sheet for every year ... (Don't know this for sure yet...)
I definitely need to get this data in Access and get it normalized. (sigh ....)
The data is so 'nice' for the Import- and TransferSpreadsheet-wizard that the 'wizard' really chokes on it ;-)
Either the data is not...
| | |
by: Acephalus |
last post by:
I am currently using this to get data from an .xls
file:string conn =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + file + ";" +
"Extended Properties=Excel 8.0;";
System.Data.OleDb.OleDbDataAdapter adapter =
new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM
",conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
|
by: garry.oxnard |
last post by:
Can anyone help me to solve a problem which involves switching from
Access to Excel (then back to Access) programatically please?
I have an Excel template which, on open, also opens an Access database
- containing a list of addresses.
Sequence of events is =
(1) Excel template opens in its default XXX.xls filename.
(2) Code runs to save the spreadsheet as XXX.xls.
(3) User clicks a button to open an Access database containing an
|
by: DrewYK |
last post by:
I have the project that may never end in front of me.
I am creating a routine that will take SpreadSheets from Excel and
bring them into Access.
I am not using any "DoCmd"s because the goal is for the import code
to be moved to a stand alone VB app which will use the Access DB as a
workspace to process the data from the spreadsheets. Quite honestly,
done right this may not even require Access or Excel to be on the
users machine. ...
|
by: afr0ninja |
last post by:
Hello!
I'm having an issue with the OutputTo function of Access. I have a few queries that I export to excel (by way of the OutputTo function) This works fine.
I then take an excel sheet and link some data from these exported sheets with other data from other excel sheets. I can create a link to one of the exported sheets. It will import the information fine, I can manipulate is needed, no issues. However, once I save the excel...
|
by: TARHEELS721 |
last post by:
I am trying to send the results of a query that runs when I click a button on my form that is based on a parameter query. The code runs without any errors but nothing is exported into my excel spreadsheet and I can't figure out why does anyone see where I went wrong in my code. I am currently using DAO Recordset. Here is what my code looks like:
Private Sub btnJE_Click() 'Exports qryJE results into excel
On Error GoTo Err_btnJE_Click
...
|
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: 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: 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: 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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
