Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
cb1's latest activity
C
cb1
reacted to
raziel3's post
in the thread
exporting access table data to excel
with
Like
.
I've had a problem with this recently...
Mar 25, 2024
C
cb1
reacted to
CJ_London's post
in the thread
exporting access table data to excel
with
Like
.
Only thing I would add is that Access does not export any format properties, only the values, so you need to confirm what format is...
Mar 25, 2024
C
cb1
reacted to
arnelgp's post
in the thread
exporting access table data to excel
with
Like
.
double check the output and format it as you wish, it's not a big deal. that is called proof-reading. there is no place for complacency...
Mar 25, 2024
C
cb1
reacted to
Pat Hartman's post
in the thread
exporting access table data to excel
with
Like
.
Another way to check the output with less code is to use TransferText or TransferSpreadsheet to create the export. I also prefer...
Mar 25, 2024
C
cb1
reacted to
arnelgp's post
in the thread
exporting access table data to excel
with
Like
.
you need to try/test it first. you may try: Docmd.TransferSpreadsheet command.
Mar 22, 2024
C
cb1
reacted to
ebs17's post
in the thread
exporting access table data to excel
with
Like
.
Excel doesn't know data types, only formats - VBA in Excel already has data types. A data type can be interpreted from the contents and...
Mar 22, 2024
C
cb1
replied to the thread
exporting access table data to excel
.
Thanks for the response ebs17, could you elaborate a little on this please, and how text files help preserve the 'data type security'...
Mar 22, 2024
C
cb1
reacted to
ebs17's post
in the thread
exporting access table data to excel
with
Like
.
There are practically never any problems when exporting, but there are certainly problems with subsequent imports. In an Excel table...
Mar 22, 2024
C
cb1
posted the thread
exporting access table data to excel
in
General
.
Are there any common issues/challenges when it comes to exporting a full table of data from an access database out to a currently blank...
Mar 22, 2024
Home
Members
Top
Bottom