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  1812 
On Oct 8, 2:29 pm, mwillia...@socal.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 TransferSpreadsheet( ) 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...
|
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...
|
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...
|
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...
|
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...
|
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;";...
|
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...
|
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...
|
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...
|
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...
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
| |
