I'm using Microsoft Access and Excel 2003 and when I export a report from
Access to Excel some of the data from the report is changing when it gets to
Excel.  For example "4a" turns into "0.166666666666667", "0-10" turns into
"36800".  Other numbers and text combinations don't ...

I am making a database to track service calls. The supervisor wants to view
summary information of the calls not cleared on a large screen monitor on the
wall through excel . This will all be on a shared drive. Supervisor also has
a specific visual layout on how he wants to view ...

I have a table that I need to export in an ascii format.  The problem is all
of the fields in the ascii file are created as left justified.  I need the
fileds with a data type of number to be right justified.  Any ideas how to
correct this?

I use access 2002. When I amend data in a table it does not copy the
amendment to the table it is linked to. Why is this? I have tried this with
several linked tables and with no success.

I have a very old Filemaker Pro file (.fp3) and no longer have the program on
any of my computers.  How do I open it in Access?

I have Office 2003 . I have a public folder where I keep requests . I want to
bring those Outlook items into Access. I found a utility on  Microsoft WEB
site to do this ( see below) but I can not find anything for Office 2003.
: Article ID : 175901

I'm trying to read from a log file to import to a table.  Does anyone have
any sample code I could use?

I do not know much about access but this is my problem
I have about 300 html files with some data that needs to be inside a database.  The data is formatted in table so that access can import a file at a time.  I can import one by one but that will take me forever.
I tried with a ...

I am using the transfertext method and a saved specification in vba to import
some data into a table.  Right now if there is a duplicate record it will
import it anyway, but I would like the import to look at 3 fields in
particular and if the imported data has the same ...

The Purpose of Resumes
Your resume is a key job-hunting tool used to get a job interview. It
summarizes your accomplishments, your education, as well as your work
experience, and should reflect your special mix of skills and

I have a macro that exports my previous months sales to all our reps but I
want to format the subject in the email to say for example the Month of
November 2007. I can use the = Format(DateAdd("m", -1, Date()), "mmmm yyyy")
in the report but how can I impeiment that in the ...

Hello, I have a MS access table that gets data when a  person fills out a
form and sometimes all the information is not available when the form is
filled, and results in some null fields. The table has the following fields.
job_id(auto number)     date(current date)     ...

I really need some assistance as QUICKLY as possible...
I have a "form" in Excel that I want to import into Access.  Actually I only
want to import specific cells/rows from this makeshift form into Access.  It
would be the exact same cells/rows from each Excel document.  Can this ...

Good afternoon
i have some data on a Query that i want to transfer to Excel.
I have allready my command but i want the file from the path  to be achieved
by a construction and concatenated with the rest of the path.

I am attempting to upsize a database in Access 2007 to MS SQL. This database
has only tables, no forms, queries, or anything else. I am already using it
on a website to power a blog, but for reasons I won't go into I need to
upsize it to SQL. According to my web hosting company, ...