|
Automating an Excel import
Once a day we recive an Excel spreadsheet that contains data for certain (but
not all) the fields in one of the tables of a database. I know that it is
possible to import these using the wizard but I wondered whether there was
any way to automate the process. For example, ideally I would like a command
button that I clicked which opened up the Windows Explorer Browse window,
allowed me t...
|
5 |
1/1/2009 10:05:00 AM |
|
|
Access 2007 error: The search key was not found in any record
I am trying to import data from an Excel 2007 spreadsheet and receive the
error message "The search key was not found in any record." I have imported
numerous spreadsheets without errors. I performed compact / repair database,
but am still getting the error message. any ideas?...
|
3 |
1/1/2009 12:14:25 AM |
|
|
Text Import Problem
Hi,
I've been importing text files through ACCESS 97, 2000, 2004, and 2007 for
many years. I just got a call from a client that said he was having problems
importing a text delimited text file using 2007. Once he selects the text
file, and tries to append it into an existing table he just gets a blue
screen after clicking on the OK button. Ha anyone had this problem before?
Thanks...
|
1 |
12/31/2008 10:14:03 PM |
|
|
Import Autonumber Problem
I'm trying to import a table with a serial number field from a Dbase app into
Access 2007, but I want to use the autonumber field in Access. I know I can't
change the imported serial number field to an autonumber field. Is there any
way to import this table so the serial number field becomes an autonumber
field? Or is there any way to get the autonumber field to match the value in
the se...
|
7 |
12/31/2008 6:00:13 PM |
|
|
The search key was not found in any record
When trying to import am excel file, I sometimes get this message and cannot
complete the import....
|
1 |
12/31/2008 4:57:01 PM |
|
|
Importing "Tab-Delimited" text files
I Link a "Tab-delimited" text file, that I download several times a day from
a vendors program, to [TableA]. Everything works fine, until another user
tries to run a query or list box from the [TableA] then nothing happens, all
returns are "Null". I probably should link to a [TableB] and append [TableB]
to [TableA]. Hopefully there's a better way as not to have to add another
manual step. ...
|
10 |
12/31/2008 5:05:29 AM |
|
|
Data lost when exported from Access 2007 report to Word 2007
I created a report in Access 2007 using a table as the source. The report
looks fine in Access. However, when I export it to Word 2007, it loses some
lines of data--not on every page, however. Some pages are fine, others are
missing a line in the middle; some miss a line at the end. If I export it to
a text file, this does not happen; nor does it happen when I export to .pdf
file. I have...
|
2 |
12/31/2008 4:53:01 AM |
|
|
Exporting as an Unformatted Test File
I am trying to export the results of a query as a text file without
formatting. The Export with formatting button is checked and greyed out, adn
I can not de-select it. Is there some sort of option that I need to set so
that this button is available?
--
Wendy C....
|
5 |
12/31/2008 12:56:45 AM |
|
|
How to Export Null Fields to Delimited-Text Format Files in Access
In doing an export, I need to have null fields show quotes. Example...
,"data", "test","","","moredate" Can anyone help with this? ...
|
2 |
12/31/2008 12:32:49 AM |
|
|
link odbc from multiple sources
I have two sources of data. Server 1 and 2 that have the same type of data
but for different stores. Right now I have to pull the data seperately and
then copy and paste in excel to merge into 1 file. Makes the process slow.
Is there a way to link both sources and essentially have them one on top of
another. Another words pull them at the same time into 1 single linked table....
|
2 |
12/30/2008 2:08:31 AM |
|
|
Export Access Report to Excel
How funny it is that a nice feature is available in Access-2003 and not
available in Access-2007. I don't know why microsoft has removed the report
convert feature rather it should improved.
If anyone come to konw please let me know and If read by Microsoft team,
they should try to include this useful feature in Access-2007....
|
2 |
12/29/2008 1:53:46 PM |
|
|
Re: KELSEY
WE WILL KNOW WHY?
>>I WILL COM FRENCE YOU
>> LOVE
>> KELSEY>>
>
>
...
|
1 |
12/27/2008 10:38:19 PM |
|
|
import xml not a problem, setting key for subtables is
I'm surprised I got this far LOL
Ok. I made an acrobat PDF form from a schema from Access. One big table and
multiple sub-tables. I was able to get the PDF form to export the xml
properly. I can import the single xml file back into access into multiple
tables.
Here's the problem:
A new record into the main table generates a PermitID (primary key,
autonumber).
I want to know how...
|
1 |
12/27/2008 6:30:20 AM |
|
|
importing video to Windows Movie Maker
Can someone please help me with this.
I have a Sony Vaio laptop with Vista 64 and I'm trying trying to import
video. I originally tried Sony Vegas 9.0, but this would crash Vista. I
then tried VMM with the same result.
I am connecting a Cannon ZR930 mini DV camcorder via firewire. The laptop
I'm using has a built-in webcam that I can import video from, but once I try
the Cannon...
|
2 |
12/26/2008 1:31:19 PM |
|
|
Problems with importing a text file in Access 2007
Access 2007 will not allow me to import a text file that contains dates. I
get the following error message:
"The specification XML failed to validate against the schema. There is an
error in the following line of the XML document: ."
Of course Access 2003 worked brilliantly! No such luck with 2007. I've
done enough research on the web to see this has been a problem for others for
...
|
8 |
12/25/2008 12:25:53 PM |
|
|
Export from multiple list items (Access 2007)
Hi
I am using Access 2007 and have used the multiple selection combo box
feature in a tables lookup property to save room on a form. Is there a way
of exporting each of the selected items to a seperate column in Excel or to
seperate fields in a query?
Regards
Steve
...
|
2 |
12/25/2008 10:14:59 AM |
|
|
link database by internet connection
Hi everybody,
I want to split my access database, so the data later i wanted to be link to
other computer by internet connection.
how to do it so my other part office can use my master database I create to
access access the link database over internet connection so they keep
updated all my database
...
|
1 |
12/25/2008 4:00:54 AM |
|
|
Automatically importing outlook contacts into access database.
I need to have my office's outlook contacts be stored in a central shared
location for all in the office and have everyone have access to view these
contacts. It's similar to using exchange but without it. The tactic I've used
is to create a database in access that links to each persons contact list in
outlook. Each person needs to export their local outlook contacts to the
shared drive ...
|
1 |
12/24/2008 4:01:01 PM |
|
|
Access import XML problems with append
I'm trying to import a set of XML files into access 2007, each relates
to a different day of data, but otherwise they should be exactly the
same. The first one comes in fine, and creates the table just fine.
but when I try to bring in the next data, the PC seems to be doing
something, but none of the records are imported. Any idea why? I can
create new tables with the data the look essen...
|
1 |
12/24/2008 2:28:11 AM |
|
|
Issues Importing .xlsb Files into Access 2007
In the last month, this problem seems to have come up. It's definitely new,
and I haven't made any changes to Access other than the normal updates pushed
through Windows Update.
Whenever I try to import an .xlsb file into Access 2007, I get the following
error. In a window titled "Import Spreadsheet Wizard", I get the following
"This file was created in a previous beta version of Exce...
|
1 |
12/23/2008 7:50:01 PM |
|
|
Batch Import
I have received a task to create a report for our email useage locally. There
is a specific userface we use for emails that I receive an extract of data.
Each day I receive an excel file which contains columns such as thread id and
name and subject line. In addition i receive about 1000 dat files that
correspond to each thread ID in the excel file. the dat file is named for the
thread ID...
|
1 |
12/23/2008 2:27:02 PM |
|
|
Linked Text File in Access 2007
I am trying to link to a text file on a share drive. Everytime I try to set
up the link, I get the Microsoft Office Error dialog box (send or don't send
message) and the database automatically closes. I have set up the share
drive location in the trust center. I have also tried moving the text file
to my c:\ drive, setting up my c:\ in the Trust Center and I still get the
same error. ...
|
2 |
12/23/2008 12:40:13 PM |
|
|
Re: MARK LEITTE
"susan roads" <susa and mailto. com> wrote in message news:... ZULA PATROL
>I WILL COM FRENCE YOU
> LOVE
> MARK
>
...
|
1 |
12/23/2008 2:48:51 AM |
|
|
Export Access Report to Excel
I understand there is no built-in way to export an Access report to Excel.
Before anyone asks why I want to do such a thing, it is because my boss wants
to view my reports in Excel. After getting this out of the way, does anyone
know of any code or macro that will export an Access report with formatting
to Excel?
Thanks....
|
5 |
12/22/2008 11:50:27 PM |
|
|
Filtering a Query then Exporting to Excel using VB
Hi,
I have a form with some combo boxes / check boxes and a 'generate report'
button for the user to generate a report based on the criteria they specify.
Using the DoCmd.OpenReport function and a WHERE condition, it successfully
opens the report for criteria the user selects.
So if the user selects the staff member as 'Joe.Bloggs' the report will only
show records for Joe.Bloggs.
...
|
2 |
12/22/2008 9:27:53 PM |