I have a client that has bought a database program that stores data in
'.tps' files.
They want some custom reports and the vendor wants an extraordinary amount
of money to do this.

Hi ... I just imported 34 excel files into an access table.  Access
designated a primary key for me.  The first of the 34 files were numbered 1
to 23603.  The remaining rows of data from the other 33 files jump suddenly
and are numbered 82185569 thru 82721859.  There are a total ...

I desperately need to be able to add/change/format cells in excel from access.
I've been searching through the forums looking for all the small pieces--
but I was hoping there was a webpage somewhere with all the VB code/commands
for doing excel formatting.

I have a working stored procedure in SQL Server 2000 that needs to be
converted to MSDE 2005 SQL Server Express.  When creating the stored
procedure in MSDE 2005 I noticed that they are stored as projects with a .sql
ending.  What changes must I make to call the stored procedures ...

How can I change the name of a table (csv) to which I have a link, via code?
The path's always the same, but the name of the table is always the current
date, such as 20070628.csv. I don't want to have to rename this file or use
the Linked Table Manager every time. (No problem to ...

I am using TransferDatabase to import a report from another database.  The
report gets named with a 1 on the end.  How can I delete the existing report
first to prevent this from happening ?  For tables, I use the following code.
Is there an equivalent method for reports ?

I have about 50 linked Acess tables that connect to SQL Server, that are
linked to access forms.  Each form is linked to a query, which is based on
many other queries.
The problem is that it takes about 30-60 seconds for the results to display.

I'm imported a comma delimited file.  After import, an ImportError table is
created, and 1 record has a unparsable record error.  Opening the source file
in Notepad, the field within the questionable record looks like:
"8101 "O" STREET LINCOLN NE"

Hi all! I have encountered a repetitive step I must take each and
every time I open one of my Access databases. Here's where I need
help:
I have an access database which when I start it up should delete the

Ive tried 3 ways of importing excel spreadsheets, opening them via file>open,
file import and insert. All three crash access as soon as I select the file
to import. I have also tried numerous excel spreadsheets.
I've reregistered dll's, reinstalled office, and removed and installed ...

Hi all! I have encountered a repetitive step I must take each and
every time I open one of my Access databases. Here's where I need
help:
I have an access database which when I start it up should delete the

We have requirement for Software Tester with experience in manual and
automated testing tools at our Gurgaon office, Kindly post/ inform  to
your friend or apply if you are interested for this opportunity.
Experience - 3-5 years

Problem: I need to email 100 dept heads revenue data specific to their
departments.
Location of Data: I have 4 queries in Access. Each query was set up to
report on 4 different types of revenue. Each query has a DeptNumber Field.

I've been running a Macro that Imports from Excel. After the Import runs one
of my field data types is changing from text to number and I'm losing data.
My Import Spec, Table, and the Excel File all have text data types before the
Import but after my table is a number. Any ...

When I try to collect data through an email with outlook 2007, using an HTML
format, the receivers of the email cannot enter information into the text
boxes. Also, there is no submit button. Is there an outlook setting that has
to be allowed to do this? Are there any special ...