Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If i
want to export this table to excel i only get it till record 2385. Do
someone know how i can solve this probleme?
To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) &
Day(Date) & "_Gegevens.xls" 'location and name where the table must be
saved
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills",
StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings
Koen 7 5120
Excel can also be limited by the number of columns, I have had problems when
exporting tables with high column count.
Also try to just use a macro to do the export and see if it works. The
convert the macro to VB and use that code if it works.
"Keon" <ja*********@telenet.be> wrote in message
news:Qe*****************@phobos.telenet-ops.be... Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills", StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings Koen
Someone may post that excel can only accept so much data! This is
probably the case here. However, whenever I'm exporting tables from
access to excel, I use outputTo instead of the transfer command! this
may allow you transfer more??????
"Keon" <ja*********@telenet.be> wrote in message news:<Qe*****************@phobos.telenet-ops.be>... Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills", StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings Koen
I'd suggest you look carefully at record 2385 of your data.
Is there something in this row which might not export correctly?
I've had data exports to Excel (albeit this was from a query) stop at a
record where I had a value of #Error in one column.
AFAIK, Excel spreadsheets are limited to 64,000 rows, so this is unlikely to
be the problem.
HTH
- Turtle
BTW - that's an awful lot of groups you're posting to. This question has
nothing to do with toolkitode or setupconfig. Or macros, for that matter.
"Keon" <ja*********@telenet.be> wrote in message
news:Qe*****************@phobos.telenet-ops.be... Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If
i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills", StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings Koen
OutputTo has more severe limitations than TransferSpreadsheet. 16,384
records per table (or thereabouts).
--
Ken Snell
<MS ACCESS MVP>
"MissiMaths" <mi********@hotmail.com> wrote in message
news:75**************************@posting.google.c om... Someone may post that excel can only accept so much data! This is probably the case here. However, whenever I'm exporting tables from access to excel, I use outputTo instead of the transfer command! this may allow you transfer more??????
"Keon" <ja*********@telenet.be> wrote in message
news:<Qe*****************@phobos.telenet-ops.be>... Hoi,
I'm using a database with alot of records in 1 table (more than 3000).
If i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills", StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings Koen
For Excel9, the limitation is 65536 records per export and 255 fields per
record being exported.
Your description of the table suggests that this is not the limitation that
you're getting.
Try compacting and repairing the database and then try it again. There may
be a problem with your table.
--
Ken Snell
<MS ACCESS MVP>
"Keon" <ja*********@telenet.be> wrote in message
news:Qe*****************@phobos.telenet-ops.be... Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If
i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills", StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings Koen
Another problem may be the field type. Is one of the fields an OLE type.
Excel may be wanting you to stick with numbers, text and dates. Also Access
has a variety of number types, not sure if Excel can accept all of them.
"Keon" <ja*********@telenet.be> wrote in message
news:Qe*****************@phobos.telenet-ops.be... Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills", StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings Koen
On Sun, 28 Nov 2004 11:19:54 GMT, "Vern" <vh*****@mchsi.com> wrote:
Try making a query that includes everything in the table. Then export the
query to excel. You should get all the records, but some of the data in some
some of the fields may still be a problem. (a text field containing only
numbers will be changed to a number field in Excel and any leading zeroes will
be dropped. It's been a while, but I think there are other probles. They are
not insumountable if you just have to have the date in Excel.)
Chuck
.... Another problem may be the field type. Is one of the fields an OLE type. Excel may be wanting you to stick with numbers, text and dates. Also Access has a variety of number types, not sure if Excel can accept all of them.
"Keon" <ja*********@telenet.be> wrote in message news:Qe*****************@phobos.telenet-ops.be... Hoi,
I'm using a database with alot of records in 1 table (more than 3000). If i want to export this table to excel i only get it till record 2385. Do someone know how i can solve this probleme? To export my tables i use folowing code:
StTotaal = stLocatieName & "\Archief\" & Year(Date) & Month(Date) & Day(Date) & "_Gegevens.xls" 'location and name where the table must be saved DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblBills", StTotaal, 1, , 1 'exporting of the table tblBills
Thanks
Greetings Koen
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alex |
last post by:
Hi all,
In MS SQL Management Console I can right-click on any Table and I have
the option All Tasks > Export Data where I can export the table to
Excel. In a View however this isn't there. I...
|
by: Gary Wright |
last post by:
I have an Access 2K database split into front and back. Quite often the
users want to do some data analysis that I have not created a report for so
they want to export some subset of the data into...
|
by: Anthony Cuttitta Jr. |
last post by:
I'm working on some procedures where Access queries are exported to
Excel, and then later on, those same workbooks are openned, and I need
to target a specific original sheet. Sometimes there will...
|
by: Ellen Manning |
last post by:
I'm trying to export an Excel2K spreadsheet to A2K. Here is a sample
of the Excel spreadsheet:
LastName FirstName Hours Location HoursPercent
Doe John ...
|
by: Regnab |
last post by:
I've got my code working so that it'll count the number of columns in
the table and move across (eg Range A-P and then range Q-W). Problem is
when I get to the end of the single letters and get...
|
by: paul.chae |
last post by:
I have a table in Access with about 3000 records. There are ~60 unique
values in the ID field for the 3000 records. What I would like to do
is automatically generate multiple Excel worksheets...
|
by: excyauseme |
last post by:
Hi guys! Do you know what is the best way to export a text file, this
one is a log file that is already comma delimited thru a module run by
my access database, to an excel spreadsheet? I need to...
|
by: smaczylo |
last post by:
Hello, I've recently been asked to work with Microsoft Access, and
while I feel quite comfortable with Excel, I'm at a complete loss with
databases. If someone could help me with this issue I'm...
|
by: CoolFactor |
last post by:
MY CODE IS NEAR THE BOTTOM
I want to export this Access query into Excel using a command button on an Access form in the following way I describe below.
Below you will find the simple query I am...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |