|
Changing info in a field
Hi there
Here is my problem. I would like to take a field that contains a 3
digit word, space space, 3 digit word. For example "F4M &X7". Is there
anyway I can delete one space of the spaces through Update Query? Your help
is much appreciated. I know that I can create another field by seperating
and then cancatenating. But that seems to much trouble. My table contains
over 2...
|
2 |
3/31/2007 10:07:52 PM |
|
|
Exporting Excel workbook to Access table
I am trying to export an Excel file (4 worksheets) to a single Access table.
The code I use is the following:
DoCmd.TransferSpreadsheet acImport, , "DataImport", FileName, False,
"Sheetname1"
DoCmd.TransferSpreadsheet acImport, , "DataImport", FileName,
False, "Sheetname2"
DoCmd.TransferSpreadsheet acImport, , "DataImport", FileName,
False, "Sheetname3"
Do...
|
2 |
3/31/2007 10:31:15 AM |
|
|
Replacing Blank Data with Text
People -
I am having a mental block..and I need your help. Does the below
'expression' will work when you have the following data field:
Data Field = Country
Blank = United States
Non-Blanks = 'listed countries'
I wrote this expression and all the data in the column 'country' comes
out blank:
Country: IIf([CMCTRY]=" ","United States")
Above did not work..why?
Gil...
|
4 |
3/30/2007 9:36:11 PM |
|
|
What is error message 31519 - Cannot Import File
Getting an error message 31519 when trying to import a file. Need help in
determining how to correct problem.
thanks...
|
2 |
3/30/2007 6:10:03 PM |
|
|
How? Export email addresses in a query to To field in Outlook mes
I am trying to either import the contents of an Access query (a list of email
addresses) into the "To" field in a new Outlook message or to export from an
Access Query. Is this possible?...
|
3 |
3/30/2007 2:34:01 PM |
|
|
exporting a list of queries in a database
I have a database with over 100 queries in. Is there a way to export a list
of the names of the queries to Excel or a text file?...
|
2 |
3/30/2007 2:04:10 PM |
|
|
Auto load table
Is it possible to automatically load a table with data from a csv or excel
file?
I want to automate a data entry process. Everday I recieve an excel
spreadsheet containing data that I have to manually insert into a table. I
would like to create a function macro that will grab the file from a
specified location and automatically upload the file into my database. Can
anyone help? Any...
|
6 |
3/30/2007 5:20:00 AM |
|
|
Transfer Email addresses to Outlook address book
I have a field in a data base for entering email addresses. Is there a way
that I can export these addresses to Microsoft Outlook contacts for emailing?
Thanks for any help
...
|
1 |
3/30/2007 4:24:01 AM |
|
|
Import AS/400 or DB2 into Access or Excel ** The Date Issue
Hey guys & gals (if any) this is my first posting to the group.
Got a nagging issue that I am trying to resolve. Google and Newsgroup
have not posted anything that can resolve what I need to do.
I have an AS/400 system here that has a date format of CYYMMDD. The C
is for Century Code and below is the example:
1061023 = 2006/10/23 = October 23, 2006
I need to convert or 'translate...
|
8 |
3/29/2007 11:30:19 PM |
|
|
Export Data in Access Table to Mulitple Excel Files
I have a table of employees and their managers. I need to send an Excel file
to each manager to review the list of their employees. Is there a way to
export the employee data to separate Excel files grouped by manager? (ie:
Excel file called Manger.xls which includes only the data for their
respective employees).
Any assistance is much appreciated. Thanks....
|
9 |
3/29/2007 8:52:43 PM |
|
|
Import to a New Table
Can a Schema.ini file be used to import into a new table or just existing
tables.
I am using the "How to create a schema.ini file programmatically" at
http://support.microsoft.com/default.aspx?scid=kb;en-us;155512, which works
for importing into an existing table, but what if i want to import into a
new table.
Problem: I have to import many files, from many sources, which are never t...
|
2 |
3/29/2007 7:17:06 PM |
|
|
Error Importing Excel Spreadsheet
When I am try and import date from a spreadsheet into an existing table, I
receive and error message and it will not import the data. I have check data
type and field names.
Thoughts...
|
2 |
3/29/2007 2:54:02 PM |
|
|
Excel Export to multiple worksheets
I've got this data in an Access table
State Date User B3-AC FTE
AZ APR 16 2006 UAUKT 7 0
AZ APR 29 2006 UAUKT 0 0
AZ APR 28 2006 UAUKT 0 0
CA APR 27 2006 UAUKT 3 0
CA APR 26 2006 UAUKT 0 0
FL APR 25 2006 UAUKT 0 8
FL APR 24 2006 UAUKT 0 8
I want to export this data to one Excel workbook, with a separate Excel
worksheet to represent the...
|
1 |
3/29/2007 2:14:00 PM |
|
|
type conversion failure error
I am trying to import a spreadsheet from Microsoft Excel. Some of the fields
are blank. The import itself works perfectly except I get import errors
(type conversion failure) for the blank fields. Any suggestions?
...
|
2 |
3/29/2007 1:52:41 PM |
|
|
Export to Excel missing text
When export a report from an Access 2000 database to Excel 2000 a notes field
is being randomly truncated i.e. not all the data in that field is being
exported. Has anyone come across this and do you have any idea of a fix? ...
|
3 |
3/29/2007 12:54:01 PM |
|
|
Export Access Report to Excel - No Data
Hi, I have an Access report, which contains detail and a "project" group
footer. I hide the detail and just see the footer data in the report. I
want to export this data to Excel, but when I do all that shows up in Excel
is 1 row with the words "text x" (where x is a number), in cells across the
top. No data.
I have Access 2000. I can export it to rtf or to csv, but not to excel. ...
|
3 |
3/29/2007 12:14:02 PM |
|
|
Language problem in exporting data
Hi All
I used this code to export my query result to Excel
Dim XL As Object
Set XL = CreateObject("Excel.Application")
DoCmd.OutputTo acOutputQuery, "qryName", acFormatXLS, "C:\Result.xls",
True
But one of fields that filled with my native language(persian) in access
converted in unreadable format!
any help would be appretiated...
|
2 |
3/29/2007 12:39:34 AM |
|
|
Exporting/Importing same Form
Here is what I am supposed to accomplish:
I have a Corrective Action Database. We e-mail out the Corrective
Actions (A Report) to individuals to fill out in word, through the e-
mail function in Access.
I now need to e-mail out a word form from the database that is to be
filled out, returned and imported back into the database. This data
must be imported into the same record it came fr...
|
4 |
3/29/2007 12:38:12 AM |
|
|
Trouble sending a e-mail to update tables, what's the best way to link tables
Hi, I have a database that so far is working fine. Now I got a new challenge
I have to put this database in 2 other locations, these locations will have
the database running with their data, but I need to have access to the data
from their databases in my database.
Now I was thinking of placing a copy of the database in a shared drive
(network) from which they will work and I will make a l...
|
4 |
3/28/2007 11:06:25 PM |
|
|
Exporting to Excel
As well as specifying the file name is it possible to specify the sheet as
well?
...
|
3 |
3/28/2007 2:44:03 PM |
|
|
Export from Access to Excel to produce Word Doc
I update an excel template using data from an Access database. I am unable
to paste the excel chart to a word doc as it is a template. As the user
wants to create a report made up of many pie charts/graphs (12 in total) with
the ablility to enter free text at the start of the report any ideas on where
to look for examples of code to save my ".xlt" to a ".xls" without opening
excel so a...
|
1 |
3/28/2007 1:54:05 PM |
|
|
Populate Excel Worksheet with Access Parameter Query Results
Hello,
I have a parameter query called 'Rev by AcctCode' that takes it's value from
a form field; Forms![SalesAssoc]![e-mail].
I am trying to find a way to run this query, get the parameter value to it,
and populate an Excel spreadsheet with the results.
Apparently, there is no direct way to use TransferSpreadsheet with a
parameter query.
Instead, could I somehow get the results ...
|
1 |
3/28/2007 1:11:29 AM |
|
|
Delimited & Fixed-length
Hello,
I wish to export my table contents to a txt file where the Field Delimiter
should be semi-colon (;) and the Text Qualifier should be a double-quote (")
but where the field's lenght must be preserved.
ex: txt file should look like :
"John.....";"Europe";"Test......"
"Tom......";"USA...";"Test again"
(the dots replace the space for readability reason)
It looks like Access only a...
|
3 |
3/28/2007 1:07:49 AM |
|
|
merging access database with a calendar
I am a novice user. I have a database with about 100 dates that I want to
merge to an annual calendar, fill in a name, and print. Can I do this within
access or is their another software that will work easily with Access?
--
Thanks for your help!!
Kelly...
|
4 |
3/28/2007 1:03:52 AM |
|
|
Import using Split Function
After reading several post I decided to try use the split function to import
data from my comma delimited text files. I was using the TransferText method
which works like a charm except that I need to add custom field data for each
record. Can I do that using the TransferText metihod?
I am trying to use the split function but some of the fields have
qualifiers. How or do I deal wit...
|
3 |
3/28/2007 1:01:36 AM |