|
Export Images/Mail Merge
Hello! I would like to export bitmap images from my Access database to a mail
merge or some other compatible file format that will allow me to place the
images in a Microsoft Word document via mail merge. Is this possible? Thanks!...
|
1 |
05.07.2006 17:42:02 |
|
|
How to merge one table and data with another in access
I would like to combine two databases into one. I exported the table from
database #1 into database #2. I would now like to take that table and merge
it into a table in database #2....
|
2 |
05.07.2006 17:01:01 |
|
|
Help please
I am creating a user friendly form, 1 pager, that track everything I need. I
want to be able to select a name from a dropdown menu, which then paste the
selected record (All fields from the query selected) to my main table (&
Form).
I want to select someone record from a list and link this individual and his
informations to the main table; maybe with a command button only visible whe...
|
1 |
05.07.2006 16:36:02 |
|
|
Export query to xml and mail that.
Hi
I have a small problem figuring out how to do <subject>.
What i would like to happen is that I have a query defined in my Access
database, when i push a button, I would like to save this query as xml and
send it as an attachment to an email.
I can do just that, just sending data as Excel instead of XML. By using the
macro SendObject I can select a query and select type. B...
|
2 |
05.07.2006 13:33:02 |
|
|
check who has an excel file open
I have a database that imports an excel worksheet as part of a vba function.
I have used other postings (notably Ken Snell's reply of 08/22/2005 to a
thread entitled "Check for open Excel workbook and then close it and Excel")
to get code that checks if the file is open before I start the import but my
query is slightly different , hence the new post.
The excel file I'm importing is o...
|
1 |
05.07.2006 13:04:02 |
|
|
Importing from Excel
I am trying to import from an Excel file to an existing table. I made the
Excel file the same at the access table (Field names). Everytime I try to
import I get the following Error: An error occured trying to import file,
"M:\blah, blah, blah" the file was not imported. I realize this is a pretty
generic error, but I have done this at home with no problem. We have an
enterprise account f...
|
1 |
05.07.2006 12:14:01 |
|
|
Use of Macro to export a Form's data records to Excel
When this Macro is invoked, it works fine except when there is just one
record in the underlying Form selection. Then the transfer issent as a null
record....
|
1 |
05.07.2006 07:18:01 |
|
|
primary keys
I am trying to import data originally set up in an Excel spreadsheet and
everytime I do it I get the following message:
"Error creating primary key on field "ID" (index or primary key cannot
contain a null value)"
I don't understand. Why can't I create a primary key on one of the fields?
How am I going to link the different tables if it won't let me set up a
primary key. It gives...
|
2 |
05.07.2006 00:19:35 |
|
|
Excel Sheet to Access Table Mapping
Hi Guys,
Just wondering if anyone knows of a method to create a form that allows you
to map data from a excel spreadsheet to fields in a access database.
I know how to create and import spec, but as our company has a number of
staff all adding data from excel reports I would prefer a form so they can
map the relevant columns on the spreadsheet to import the data themselves.
As part ...
|
3 |
04.07.2006 18:51:33 |
|
|
Updating DBF Tables
Is is possible to update DBF files within Access. Can this be done in a
multi-user environment?...
|
2 |
04.07.2006 18:37:25 |
|
|
cv writing
could anyone please send me a blank cv which l can use to write one
thank you very much indeeddecorator...
|
1 |
04.07.2006 16:13:01 |
|
|
Database Attachment Error
Hi,
When i open an Access database that has ODBC connections to SQL I get the
following error
"Can't attach application tables to data file, try loading again or manually
attach tables using attachment manager in MS Access. This may not be the
correct database to attach to.
BAd File name or number"
Firstly can anyone tell me where I would find attachment manager - i see a
linked...
|
1 |
04.07.2006 14:50:01 |
|
|
truncation of "memo" datatype during export
Access 2000 SR-1
Problem Description:
-------------------------------
I have the following query which I am using to export data into CSV
format. In the resulting CVS file I am finding that the "description" ( of
"memo" datatype) column is being truncated. When I export in html format the
data does not get truncated. I need the data in a CSV format.
Any idea how I can work around ...
|
3 |
04.07.2006 12:46:02 |
|
|
Import Spreadsheet in Access Database
Please help. I have a spreadsheet that is used to import data in access
database. I opened MS Access -> Get External Data -> Import, then I got the
following error message:
"The wizard is unable to access information in the file C:\...Test.xls.
Please check that the file exists and in the correct format"
If I opened the spreadsheet, then it's ok. I did not get the above messge.
I...
|
2 |
04.07.2006 05:58:02 |
|
|
Data import to excel
I have an access database...
With lots of financial information, its very easy to do some reports in
access...
But there are other stuff i need in excel, but when i import reports
from acces into excel, the format is lost, the reports have to be
reformatted.
How would i go about getting information into excel from access, so i
can manipulate it. using SQL.
I guess im asking how do i conn...
|
2 |
03.07.2006 20:44:45 |
|
|
an error occurred while trying to import file
I am using Access 2003 SP2 and continue to get this mesage while tryingto
import a Excel 2003 SP2 file. I have reviewed the column headings there are
no leading blank spaces. Ihave changed the configuration of the import
several times new table, existing table, Create index,no index, etc... I
have even tried to save it down to a .CSV with no success. Any suggestions?...
|
2 |
03.07.2006 20:41:46 |
|
|
export 1 record selection in Access database to Excel spreadsheet
I have a macro to export Mail Merge data in a form of selected records in an
Access database to an Excel spreadsheet.
With multiple records it works fine, but if there is just a single record to
transfer, it generates a null entry spreadsheet....
|
2 |
03.07.2006 20:40:28 |
|
|
How do I automatically import a file that changes name ea. day
...
|
2 |
03.07.2006 20:20:15 |
|
|
Access/SQL Database - Purge SQL tables to import fresh data
Is there a quick way to purge the SQL data? Doing a delete from the Access
front end is slow and painful. Do I go into Enterprise Manager and drop the
table?
Help please...
|
3 |
03.07.2006 18:53:18 |
|
|
how do I clear data and reuse database
how do I clear data and reuse the database setup with forms, queries,etc?...
|
2 |
03.07.2006 16:01:35 |
|
|
Opening a specific Word file in Access 2003
When I use the wizard in Access and attach a Word document to a command
button I need to know how I specify one particular Word document , later to
open a query attached to the document. I can se the code behind the button (
"Word application" ) but how do I specify the path to the letter ?
--
Datakons...
|
1 |
03.07.2006 08:28:01 |
|
|
Export to CSV file
I need to create a CSV file with different record typess but each record
totals 300 bytes. I know how to export tables and queries but so far I've
only used single tables or queries. Can anyone help please? This is like a
redefine statement in COBOL for those who know it....
|
2 |
03.07.2006 07:34:29 |
|
|
Data from web form to Access
I have an Access database for which ideally we would have a front end form on
the net. The form is for clients to submit artwork data (e.g. prices and
volumes) as well as jpeg images.
With my limited knowledge of servers and programming I found someone who
will develop the form for me. Problem is how do I get that data into my
Access db? i.e. What format should I ask him to provide and t...
|
1 |
02.07.2006 14:21:01 |
|
|
Import from EXcel to Access
Hello,
I have 5 spread sheets with same columns but different data that I need to
import into one table in Access.
I can import the first sheet then when I try to import the second sheet to
the existing table I get an error message stating an error has occurred.
Any idea's to what can be causing it
Thank you very much...your offered is truly appreciated.
...
|
9 |
01.07.2006 07:43:06 |
|
|
export to quickbooks
When I try to export an IIF text file, access shows an "read-only" error
message maybe because of the extension "IIF".
Do you know how to work this around?
Thank you!...
|
2 |
30.06.2006 20:55:39 |