TransferSpreadsheet
Fri, 19 Sep 2008 15:32:01 -0700
I am using 2 macros (TransferSpreadsheet) to export 2 queries to 2 different
Excel spreadsheets. I am puzzeled by the fact that one runs perfect, while
the other one totally messed the contents in the workbook (also causing one
workbook with different sheet name in the same workbook into mess). I am
using Of ...
|
MS Access Crashes when Importing/Exporting
Fri, 19 Sep 2008 12:17:00 -0700
Using Access 2003. First time ever having an issues importing/exporting
Excel. Anyone out there encounter this, and if so, what was the solution?
Thanks! ...
|
How can I import non-delimited text file into access
Fri, 19 Sep 2008 10:47:31 -0700
Hello i have a non delimited text file and no fixed width either. How can I
import them.
Data has a name, street address and city state and zip
I need the name in one field, the street address in another and city state
and zip in a third field.
Data looks like this in notepad and has 4 blank lines betw ...
|
Searching Embedded Documents
Fri, 19 Sep 2008 10:41:01 -0700
I'm wondering if there is a way to search for keywords inside of a Word
document embedded within an Access database. ...
|
Export serial date to excel as a string
Fri, 19 Sep 2008 07:44:01 -0700
I have a access 2007 database that stores all the date fields as a serial
numbers. For instance 26238 is really 11/1/1971. I need to export the
database into excel so I can read it on my mainframe as 1111971. The
mainframe cannot convert 26238 to a date, it just sees it as a number 26,238.
That is why ...
|
Linked table
Fri, 19 Sep 2008 03:54:01 -0700
Hello everyone,
I'm back with some new doubts that I hope someone can shed some light.
I created an Access DB for a client, divided it in FE and BE, created a
Pilot DB that on startup checks to see if there is a newer version of the FE
and updates it via intranet when client starts it.
I have several clien ...
|
Automate a backup via exporting?
Thu, 18 Sep 2008 22:16:01 -0700
HI -
I have a database application used by about 8 people in a Hospital
department, fairly actively. The nature of the situation is such that every
now and then, despite best efforts, we get a corruption crash. Leaving aside
the various things I am doing to prevent crashes, I am wondering about adding
a b ...
|
|
|
space filled field in fixed length file
Thu, 18 Sep 2008 13:27:02 -0700
I have field to export that either will have 8 characters or will be blank. I
need the blank records to keep the 8 character position as this is a fixed
length file. I could use the help. ...
|
Updating a spreadsheet from Access
Thu, 18 Sep 2008 12:22:00 -0700
I have "superiors" who want their own spreadsheets updated with information I
keep in Access. Is there a way I can set up a loop that searches a column in
"TheirReport.xls" for a primary key and then update that row from Access? ...
|
non-imported fields with errors
Thu, 18 Sep 2008 08:42:01 -0700
I am using a saved import to import selected fields from an excel database
into access. Everything imports into the appropriate table correctly, but I
receive an error list that includes type conversion errors for multiple
fields that are not imported. It's not a huge problem to just delete this
each week ...
|
