j*******2
发帖数: 309 | 1 I cannot import access2007 database from SAS import wizard. The menu only
shows MS2000/2002/2003 database. what should I do to fix the problem? Thanks
! |
d**********r
发帖数: 24123 | 2 Save as excel 2003 file or use DDE |
j*******2
发帖数: 309 | 3 Thanks for your reply. The problem is the access dataset is too large. If I
export the dataset as excel, I can only export 65,000 records a time. It's
not convenient. So I want to try importing from SAS. What is DDE?
【在 d**********r 的大作中提到】
: Save as excel 2003 file or use DDE
|
c*****1
发帖数: 131 | 4 you can try to export access 2007 to text file. Very easy, you can google it.
Also, save access 2007 to access 2003 should be very easy too.
I
【在 j*******2 的大作中提到】
: Thanks for your reply. The problem is the access dataset is too large. If I
: export the dataset as excel, I can only export 65,000 records a time. It's
: not convenient. So I want to try importing from SAS. What is DDE?
|
j*******2
发帖数: 309 | 5 still I can only export 65000 records a time.
it.
【在 c*****1 的大作中提到】
: you can try to export access 2007 to text file. Very easy, you can google it.
: Also, save access 2007 to access 2003 should be very easy too.
:
: I
|
c*****1
发帖数: 131 | 6 This problem occurs because you cannot export a table that contains more
than 65,000 rows by using the Export data with formatting and layout option.
To work around this problem, do not click Export data with formatting and
layout when you export a table that contains more than 65,000 rows.
Let me know if this works!
【在 j*******2 的大作中提到】
: still I can only export 65000 records a time.
:
: it.
|
j*******2
发帖数: 309 | 7 It works!Thanks a lot!
option.
【在 c*****1 的大作中提到】
: This problem occurs because you cannot export a table that contains more
: than 65,000 rows by using the Export data with formatting and layout option.
: To work around this problem, do not click Export data with formatting and
: layout when you export a table that contains more than 65,000 rows.
: Let me know if this works!
|
