Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving data between excel and access
I currently have code written that moves data from Excel
to Access by 1st deleting all the data in the Access and replacing with the data in Excel. However, my code only clears the data, and the empty record ("row") is still showing. Can I completely remove the record? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving data between excel and access
Q. Can I completely remove the record?
A. Not without compacting the database. Sub CompactDatabaseX() Dim dbsNorthwind As Database ' Make sure there isn't already a file with the ' name of the compacted database. If Dir("NwindKorean.mdb") < "" Then _ Kill "NwindKorean.mdb" ' This statement creates a compact version of the ' Northwind database that uses a Korean language ' collating order. DBEngine.CompactDatabase "Northwind.mdb", _ "NwindKorean.mdb", dbLangKorean Marty -----Original Message----- I currently have code written that moves data from Excel to Access by 1st deleting all the data in the Access and replacing with the data in Excel. However, my code only clears the data, and the empty record ("row") is still showing. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving excel workbook with access query to another folder | Excel Discussion (Misc queries) | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Moving an Excel pivot table to access | Excel Worksheet Functions | |||
Moving linked Excel/Access files to another machine | Links and Linking in Excel |