this is more about batch export: when a data is view in print preview, i
want to be able to export each page (ex. 152 page report) into individual
files and rename each file based on the name of a field on the page.

turn 1 152-page report into 152 individual files.

does this make sense?

if so, can this be done? any suggestions?

Hello,

I am currently having an issue exporting a report from access to excel. The
report contains a detail section and two footers that subtotal the detail by
two different groupings. When I export to excel, excel drops the name of my
subtotaled fields into the cell I want the subtotals in, creates an
additional column, and drops my formulas into the offset column. When I was
developing this report originally, I was able to export my data perfectly.

Does anyone know what I am talking about and can help. I want to avoid
setting up an excel template at all costs...

Frustrated,
-Jeff

I have an Access 2007 D-Base with 6 tables. 3 of the tables I would like to
export to an Excel file, one table on a Sheet. I would like a button on the
Switchboard to accomplish this for me. What would the best way to go about
this?

I have Access 2007 and I input work data to it daily. I woul like ot see if
there is a way to update my excel file (data, graphs) when I input new
information in access.

I need to duplicate some Access tables in another db. Is there a way to
export the table design (ie. Field Name, Data Type and Description)?

Thanks

I am saving a table out to a fixed length .txt file to a mapped drive on our
network. Is it possible to pass the password for that location, within my
DoCmd.TransferText line of code?

Thanks in advance!!
Marty

I have a text file where the record line length is about 1934 chars long. In
fact it wraps in the text file. Is there a limit to the length of record
that can be imported into access table using import specs. Also, do I change
decimals from the record layout design to numbers in the import specs.
Thanks

Hi,

I am preparing a databse (MIS) which keeps details of work done of about 150
employees.
Idea is that i import lot of data from excel and other systems into the
database and daily i generate a "daily final report".

Point i am stuck is:- I am unable to rename table using today() command. But
I can rename it using now() command.

Could somebody help me with two things.

First: A code which renames my final report (MS access table) named as
"final" with today's date. The report table s daily named as "final". so the
code should directly go and rename "final" table into date.

Second: A code which can export all the tables into one excel sheet, with
each table in one worksheet. Please do not advise tradnsferspreadsheet
function because i wish to prepare a monthly report with details of all the
30 days. Each spreadsheet being one day in excel.

Any help us deelpy respected. This community has helped me in each and every
small or big project. I have learned a lot from this forum. Hats off to all.

Thanks!
Boss

How can I import an Excel table into Word and still keep the link? Using Win
XP and running Word 2007.

Hi,

I created an application that manages staffing actions. I created a button
that imports an XLS file from a set directory on C drive using the following
syntax:

DoCmd.TransferSpreadsheet transfertype:=acImport, _
tablename:="Candidate Test", _
FileName:="C:\New Promotion Tracking\Promel Test.xls",
Hasfieldnames:=True, _
Range:="Sheet1!", SpreadsheetType:=5

works great.

[Candidate Test] table is linked to Table main by the field SA (one to
many). In order to show the update to a child form I need to update all empty
SA with the SA from the main table.

I use the SQL statement:

SQL = "UPDATE [Candidate Test] SET SA = " & SA_temp & " WHERE (([Candidate
Test].SA) Is Null)"

Any attempt to udate the table gives me a -503 in the field. i searched the
net and the only thing I could come up with is server unavailble.