I have a query that pulls the information below.  I export it to excel to
create a graph, but the time fields are giving me problems.  The duration
colum in access is formated at SHORT TIME. If it isn't, I get a decimal
number that doesn't make sense (see below).  The other times ...

Good morning,
I need to write code to link to a txt file one fixed width and one with "|"
delimiter.
The 'Get External Data' on the Access I have does not line up well thus the

Please need to link my Access DB to a weighing machine.
How can I do that?
I need the weigh automaticaly pass from the machine a form in my database.
The machine is linked in com1.

How do you query by record number? For example, I would like to see
records 300-1500 in a separate table.

I have a query that returns a single row of summary data. I need to
export it to Excel when a user clicks a button. When it exports, I need
the output to run vertically rather than horizontally.
That is, instead of:

I have an access database with a table linked to an external text file.
Occasionally the location of the database and the text file change (but
are always in the same directory). Is there a way to have the location
of the external text file be a relative, rather than absolute path ...

I need to import data from Excel or another Access table (does not matter
which).  I need to match up data from column C with new column.  When column
B has 12345 entry and I need to import 54321 in the same row but in column C.
This is for cross ref of one part number to an ...

I am linked an excel sheet with microsoft access.The Excel sheet contains a
column named Part No
It has data like this
Part No

I need to import data from an OBDC data source.  The table from which the
data is taken is very large (many columns).  The import fails because the
record is to big.  How can I restrict the import to the columns that I need?

I have got the code for importing data to access. I want to know the
code for transfering data from a particular table in my DB to my C:
drive as an Excel file. How to do the same?
I have created a macro using Action OutputTo and then ObjectType as

how to convert the .csv to .mdb file in ms-access

Rephrasing my question dated 5/9/06.
Do I have to download on my PC:
1) Windows Server 2003
2) Microsoft ASP.Net 1.1

I have to export a spreadsheet (from my harddisk) as a table in DB and
after doing some operations on it I have to export the Ouput
Query/Table as a spreadhsheet to a different place in my Harddisk.
Im presently using 2 set of codes copied from 2 different websites to

I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.
The first thing I did was select and Edit Copy the rows from the CD I
wanted.  Then I closed the CD and opened my current ...

I have 2 needs:-
a) I want to import excel data to an existing table in my DB. While
doing so, I want to delete the existing records in the table. If I use
the following code (Pinched from the NewsGroup)