How to Export Null Fields to Delimited-Text Format Files in Access
Tue, 30 Dec 2008 16:10:06 -0800
In doing an export, I need to have null fields show quotes. Example...
,"data", "test","","","moredate" Can anyone help with this? ...
|
Data lost when exported from Access 2007 report to Word 2007
Tue, 30 Dec 2008 13:19:38 -0800
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 ...
|
Import Autonumber Problem
Tue, 30 Dec 2008 06:36:01 -0800
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
fi ...
|
Importing "Tab-Delimited" text files
Mon, 29 Dec 2008 22:14:05 GMT
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 [Ta ...
|
Exporting as an Unformatted Test File
Mon, 29 Dec 2008 12:00:03 -0800
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. ...
|
Automating an Excel import
Mon, 29 Dec 2008 06:37:02 -0800
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
butto ...
|
Export Access Report to Excel
Mon, 29 Dec 2008 00:13:01 -0800
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 featu ...
|
|
|
Re: KELSEY
Sat, 27 Dec 2008 16:38:19 -0600
WE WILL KNOW WHY?
>>I WILL COM FRENCE YOU
>> LOVE
>> KELSEY>>
>
>
...
|
import xml not a problem, setting key for subtables is
Sat, 27 Dec 2008 01:30:20 -0500
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 ...
|
importing video to Windows Movie Maker
Thu, 25 Dec 2008 21:16:00 -0800
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 us ...
|
