I'm exporting data from Access to excel.  I have an append query that pulls
the info that I want to export, and I have a Macro that runs the export.  I
was wondering if there was a way that Excel can automatically create a new
file everyday this process runs?

I have a problem using named ranges when using the TransferSpread function in
Access. It gives me "Can't find object error".When I use ranges like A1:B1 it
works fine.The problem is that I can't change all the ranges every time
something changes in the spreadsheet. Is there a ...

I recently returned to an application and discovered some very odd behavior.  
This is in Access97 with the data in a _be file on a server.
I use a continuous form to display records meeting certain criteria.  The
form has a button  to click to view the details of each of these ...

Hi - first apologies, I posted this yesterday but can't find the post.
We have a staff who needs to work with an XP database but she has Access
2000 and can't upgrade b/c another app requires that version.  She's the only
person who will need this db.

I am trying to display all records from 10 different tables in access.  The
tables are being fed by data that is updated constantly by users using forms
through which to input that data.  I want there to be 1 common table or form
in which I can display all the data from all the ...

I am trying to import a file into access where some of my records values are
a space. The space character is correctly displayed in the text file as " "
but Access trim the value on import and set the field to null in the
destination table. The import is carried out using DoCmd ...

Hi
Please Help this newbie! I need to populate Access table (or SQL table)
with info from several .csv files that gets dumped into a c:\maildump
directory. Thereafter the .csv files to be archived to c:\updated

I'm linking to an Excel file, and one field containing numeric data
(formatted as general in Excel) appears in the linked table as #Num!. When I
import the same file, rather than link, the data comes in okay. I don't want
the user to have to import the file each time. How can I ...

I would like to use an Excel worksheet as a data entry form for the sales
quantity budget: week number in the columns, products in the rows (last
years quantity by week in the following row for reference).  Each worksheet
would be a separate customer group.

Hi, we have a user whose work requires her to use Access 97 or 2000.  She
needs to use (will be the only person using) an XP database.  Can the db be
converted backwards?  I was considering exporting every object to Excel and
then importing in the old version of access, but kind ...

Im using "DoCmd.TransferText acImportDelim, , "testimport", FileName" - Some
fields generally contain numeric data but somtimes these numbers will also
contain a letter as the first character i.e.(Q457.778). The created table
"testimport" will assign field type "numeric" but if ...

I have a database that contains a number of linked tables.
I need to be able to be able to copy the database to a CD so that I can
access it whilst at an exhibition.
Problem is, when I copy the database is obviously loses the data contained

3/30/2005.
Dear Madam/ Sir:
A) I have a very large collection of Arabic-English different glossaries
(about ONE million various terms in both languages) that have been saved over

I have a one column table like this:
Document Number
123456
123457

I have some code behind a form that basically deletes data from a temp
table, runs a query to append new data and exports it as an .xls file. Two
fields are data type date/time and are set as short time (throughout the
database) however the export formats the time of for example ...