|
Import by append query
I used Excel 2000 to create a spreadsheet and tried to import it into Access;
I kept getting a message saying an error occurred and the file was not
imported. I tried double-checking the fields to make sure they were right
(date, long integer, etc.).
Finally, I saw a posting about linking to the spreadsheet and then doing an
append query. So I was able to link the spreadsheet, but whe...
|
1 |
22.06.2006 21:00:02 |
|
|
Visual Foxpro through ODBC
Hi
I am having trouble importing into access a Vosual Foxpro dbf file. The
file itself doesn't import through the standard import utility as it is not a
standard DBF filie, you have to connect to it through ODBC.
When I try this I get an unreserved error -7778 message which has no info on
it, just an OK and help button.
Has anyone ever come across this or have any ideas as to w...
|
2 |
22.06.2006 20:14:48 |
|
|
Format Excel from Access
Hi,
Do you know how to format Excel from Access particularly how to:
merge cells
set fill color
set font color
set text alignment
set font type
set font size
set border
Thank you
GL...
|
2 |
22.06.2006 19:25:02 |
|
|
How doe I copy an Excel cell into a Access memo field and retain .
My need is simple (I think!), I have a spreadsheet with tet in cells, the
text cell have multiple lines and therefore alt return has been used. I want
to copy this data into a Access memo field, however whenever I do this (or
link the spreadsheet) the ine breaks are all removed and I end up with on
contious string of text?...
|
1 |
22.06.2006 19:01:02 |
|
|
How do I auto e-mail from Access without using Outlook?
My company has been using Outlook for years and I have a database that has
been utilizing Outlook to automatically send out a report to amail group for
almost as many. Well my company switched to Lotus Notes Domino w/e-mail and
stopped Outlook. Needless to say my MS Access program stopped auto e-mailing.
I am completely unfamiliar with Lotus Notes and their e-mail system and have
had lit...
|
2 |
22.06.2006 15:07:01 |
|
|
Export to Excel problem
General info:
MS Access 2003. My database has Access 2000 format.
In my Access database I use ODBC sources of data (SQL server).
My problem description:
When I use SendObject command to email data in MS Excel format, text fields
with Null values become empty in MSExcel (they do not contain any information
but they are not Null - that I checked with IsNull() function).
My colleagues th...
|
4 |
22.06.2006 13:21:10 |
|
|
transfer spreadsheet
Hi,
I am trying to import an excel spreadsheet where i want the 2nd sheet in the
excel file. it is named price. i tried to put the name price in the range
section but access is telling me the DB could not find the object "price". I
have spelt the name and file location correctly so i am a little lost. Can
anyone help out here?
Thanks
George...
|
2 |
22.06.2006 11:02:04 |
|
|
?? How to Export Existing DB's DDL ??
Hi everyone,
I have my Access 2003 database, complete with index definitions, value
constraints and referential constraints. Now I would like to export the
underlying DDL. It seems this cannot be done. Am I missing something?
Please note that I am *not* asking how to export the data within the
database, only the table structures (table/index definitions and
constraints).
Thank you...
|
2 |
22.06.2006 09:36:34 |
|
|
How do I make the 1st row in Excel the header row?
I have exported my address book from Outlook Express to a .csv delimited
file. It converts the data to Excel but does not designate the 1st row as
the "header" row. I cannot figure out how to designate the first row as the
header row, so I am unable to import the data where I need it to go. The new
database requires a header row. Is there anything I can do? Thank you.
Sherijo...
|
2 |
22.06.2006 05:32:42 |
|
|
Importing a file
I am importing names and addresses into a database from Excel files. Each of
these has an account number. After importing, the database rejects those
that are already in the system with the same account number. That's what I
want. I only wan to add the new ones. However, I would like to capture a
list of the new ones accepted. Is there any way to do this?
Sal...
|
3 |
21.06.2006 18:53:01 |
|
|
Access Importing
I am trying to import data into Access. I have tried importing both a
spreadsheet and text file using the transferspreadsheet and transfertext
options. Each time I get the 2391 Error message (Field F1 doesn't exist in
destination table). I am not using field names in my files (and cannot since
that would mean manually inserting them). Since the hasfieldnames option
exists I would think th...
|
3 |
21.06.2006 17:34:02 |
|
|
How do I export a table to text without CR/LF. I need a flat file
My table has 22 94-byte records. I need to export to a single 2068-byte
record that doesn't contain any CR/LF....
|
6 |
21.06.2006 17:30:02 |
|
|
CSV file to Access table and losing the leading zero
I have an Excel spreadsheet that contains a date field entered in six digit
format, for example 063006, 043006, and so on. I need to convert it to a
csv file and then import it into an Access table. It is formated as text,
and entered with all six digits. After conversion, the CSV file shows it in
six-digit format.
However, after a transfertext in VBA, it ends up dropping the leadi...
|
5 |
21.06.2006 15:33:30 |
|
|
how do you merge creat business cards from access
I need to create 2 business card per person on a 5371 avery business card
from a excel data base. How do I do this after I import it to acess...
|
2 |
21.06.2006 13:47:59 |
|
|
Create local copy of Linked Table
I have a database with 20 linked tables. I want to take an image of those
tables once a day and create a copy of tables within another database for
endusers to access. If I do a transferobject macro the resulting table
remains a linked table, not as a stand alone copy.
Thank you in advance for any all input....
|
3 |
20.06.2006 21:59:02 |
|
|
Excel templates and transferspreadsheet method
Hey!
When does an excel template get applied to a spreadsheet created by the
TransferSpreadsheet method?
I am mass exporting Access data into regionalized spreadsheets for
distribution and need to apply formatting and a variety of cell formulas to
the exported data - any suggestions other than writing a macro and running it
on each spreadsheet?
Thank you for everything!...
|
3 |
20.06.2006 21:40:02 |
|
|
Exporting Data
Hi,
I'm using SQL Server 2000 with Access (.adp format) as frontend. I want
to export data from select query from 3 tables in SQL Server to a text
file using some user Interface in Access forms.
Previously when I was working in .mdb format I used TransferText method
to export data from Access Query to .txt file, but Now TransferText
method does not recognizes the view I have created in SQL S...
|
2 |
20.06.2006 19:53:18 |
|
|
Exporting mass MS Word and Excell OLE's to seperate MS Word and Excell files from Access 97 DB
Dear Readers,
I am intern at an IT company. I have been given a task to extract MS
Word and Excell files, stored as OLE's in a MS Access 97 database.
There are several hundred files, so I was wondering if there was a way
to automate a process to extract them into one directory. They need to
be in there own prospective files and formats (.doc and .xls). Thanks
in advance.
...
|
5 |
20.06.2006 19:52:24 |
|
|
can vb/vba listen for a network connection?
I have inherited code that is trying to append txt file information from one
location into an access database in another location. I think I am
experiencing network outages and loosing my data. How do I modify this code
to 'listen' for the connection while it is appending the data?...
|
2 |
20.06.2006 19:43:08 |
|
|
Linked table shows no data
I am trying to link a .CSV file to Access. When using the Link Text Wizard,
I see the data that's in the table and complete the steps. Once the steps
are completed and the table is linked, I open the table and there is no data.
The field names and only one row of blank data.
I linked two other .CSV tables and the data shows. Any idea why the data is
not showing for this linked table?...
|
4 |
20.06.2006 19:33:25 |
|
|
Using a parameter to name the spreadsheet with transferspreadsheet
Hey!
I'm using the transferspreadsheet method to mass export query results from
access 2003. A bit of what I'm doing is:
DoCmd.TransferSpreadsheet acExport, , "qryMROSort", "C:\name.xls"
What I want to do is name the spreadsheet after the passed parameter from
the form to the query etc. If the value passed to the query is "MyName", i'd
like the .xls to be named MyName.xls. Somethi...
|
3 |
20.06.2006 15:04:01 |
|
|
Allow table linking in MS Access based on relative paths
Requiring absoulte path means that I cannot develop and test an application
on a machine with different directories
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in t...
|
9 |
20.06.2006 11:05:01 |
|
|
importing from excel with formulas
i have tried to import an excel spreadsheet that had a countif formula for
each row into access. when i have done this i lose this ability to perform
the function. I would still like to be able to add to the table and have a
method of continuing this countif function.
Any thoughts?...
|
2 |
20.06.2006 07:43:43 |
|
|
MS Access Error - 3155
I have a custom MS Access app which works on some XP Pro PC's and not others.
All PC's are running this .mdb are MS Access 2003 on XP Pro. When
performing a particular task in our app, 2 of our 5 PC's error, saying that
it cannot insert a record into a particular ODBC table (we are connecting to
mySQL ver 4.0.24_Debian-10sarge1-log).
I have carefully relinked the tables and the ODBC...
|
3 |
20.06.2006 02:05:01 |
|
|
Importing Text files into Access
I recently had a a harddrive crash and had to have a new version of Office
installed on my PC. Now, in Access, I no longer am given the option of
importing .txt files. When I try to import data into Access...it only give
me the option to import other Access database files, Windows Sharepoint
Services, or .xml files. Do I have to install some type of add-in so that
it will give me t...
|
2 |
20.06.2006 01:25:22 |