Saving Access infomation into an Excel file.

[andrest]

Hi! I want to create Excel files every time an Access Database is populated so I can later on repopulate the database with any of the saved Excel files.

I'm a junior programmer and I'm on my own with this problem. Any suggestions?

Thanks in advance.

Andre

 

[edderic]

you can better make up a backup of the database ;-) Eric De Decker
vbg.be@vbgroup.nl

 

[andrest]

Thanks for the prompt response Eric.

I had not considered that option. Wouldn't it take alot of space to create thousands of databases.

Andre

 

[edderic]

I understand

a example to copy tables to a Excel file

Set Rst = New ADODB.Recordset
Rst.Open "rpKortOverzicht", cnAdo, adOpenKeyset, adLockOptimistic

Set xlApp = New Excel.Application
xlApp.Workbooks.Open (App.Path & "\RapportBlank.xlt&quot

If Val(Mid(xlApp.Version, 1, InStr(1, xlApp.Version, ".&quot - 1)) > 8 Then
With xlApp.Sheets(1)
.Range("A2&quot.CopyFromRecordset Rst
Rst.Close
Set Rst = Nothing
End With
End If Eric De Decker
vbg.be@vbgroup.nl

 

[andrest]

Thanks Eric, I'll give it a try and let you know.

Thanks.

Andre