I am working with a very old Telephony switch and am charged with extracting
data from the switch and into a database.  A staff member in Telephony has
created a script that pulls data off the phone switch every day into a .prn
file.  the file is a comma-delimited file with no ...

What do I have to do in order to store and short  time with the following
form :
Hour (optional) : Minutes : Seconds . Milliseconds
The reason is because I want to store, sort data (time) and extract results

I want to import a csv file into a table.  The format of the csv file is
fixed and I can not change it.  
The formart looks like
ABC,FGD,123,TEST

is there something like a binary_checksum function in Access (2003). (MSSQL
aggregate func)
I'm trying to create some sort of synchronization between Access & another
DBMS  and I want to know if something on a particular row has really changed

I typically get an ASCII fixed width layout text.  With each, I also get a
.txt layout document.  How can a turn the layout document into an import spec
file?  (Each file's layout is different and Here is a sample of a layout file
I get.

I'm bumping into a limit of 16,384 rows when exporting to
Excel from Access.  I seem to recall being able to export
to Excel up to the Excel limit of 60k+ rows, but now I
can't get past 16,384.  Is this lower limit for real or do

When I import a text file some of the fields with zeros do not import. The
fields are blank.  No rhyme or reason why some zero fields import and some
don't.  I have written an update query to add the zeros but is there way to
correct the import problem??

I have an Excel spreadsheet that is created each time an Access form is
executed.
wks.cells(j, .Fields("MonthNumber") * 2 + 1) = .Fields("Total")
  .MoveNext

how can I link the data in access to an excel spreadsheet
If I change a value in access I would like it to change in the excel
workbook also

Hi.  I have been trying to save my query results as an Excel document at the
push of a command button, but it is not working.  I also want the user to be
able to enter the file name to save the results as.
I have tried doing this using a Macro, using VB (both using

I have an MS Access app (it's an mdb, not an adp) that is tied into a SQL
2000 backend. One of the forms is in bound mode to a single row in one of
the major tables (there are some 15000 rows but I do a select on it to just
get one row at a time).

Is there a way to export data from access to an existing excel file - just
overwriting what's in the excel file rather than replacing the entire file?
thanks

Help,
Refreshing Text Link in VB & VBA
In my VB App or inside a VBA code how can I refreshing the table link to an
external text file without receiving the error:

I use an automated scheduler to run macros in Access with no problem while
the workstation is either logged onto or logged off.  Now I am using the
"outputto" command to send snapshot files to another directory, but it will
not completely finish sending the file(s) until the ...

I am using Access 2003 and need to link some tables created in Access with
others imported from an SQL server database. The keys on the SQL tables are
in Binary and although Access appears to retain the Binary data type in
Access I cannot create a Binary key on my Access produced ...