-
FlexPro
- Auf einen Blick
- Features & Optionen
- Einsatzgebiete
- Alle Vorteile
- Neu in FlexPro 2021
- FlexPro gratis testen
- FlexPro View OEM Freeware
- Kaufberatung
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
- Produkte
- News
- Support
- Unternehmen
- Jobs
- Kontakt
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
Import data from an excell workbook
Home > Community > Automation and VBA > Import data from an excell workbook
- Dieses Thema hat 2 Antworten und 2 Teilnehmer, und wurde zuletzt aktualisiert vor 17 Jahre, 2 Monaten von
Nicolas Beaupré.
-
AutorBeiträge
-
Januar 12, 2006 um 11:45 pm Uhr #12424
Nicolas Beaupré
MitgliedI got an excell workbook “blast2” witch is inserted in my database. I want to access the data in it or import it in DataSets. This workbook as more than one sheet. I’ve put an exemple of that workbook in attachment.
I’ve created an ExcelFolder object that way and it refer to the correct element.
Dim fExcell As ExcelFolder Set fExcell = ActiveDatabase.RootFolder.Object("blast2", fpObjectTypeExcelWorkbook)
How can I access, for exemple, the data in the C:5 cell of the tir1 sheet ?
Januar 12, 2006 um 11:45 pm Uhr #8105Nicolas Beaupré
MitgliedI got an excell workbook “blast2” witch is inserted in my database. I want to access the data in it or import it in DataSets. This workbook as more than one sheet. I’ve put an exemple of that workbook in attachment.
I’ve created an ExcelFolder object that way and it refer to the correct element.
Dim fExcell As ExcelFolder Set fExcell = ActiveDatabase.RootFolder.Object("blast2", fpObjectTypeExcelWorkbook)
How can I access, for exemple, the data in the C:5 cell of the tir1 sheet ?
Januar 13, 2006 um 12:05 am Uhr #8702Bernhard Kantz
TeilnehmerYou can create a ExcelDataLink.
In VBA you could use this code:
Dim oExcel As ExcelFolder Set oExcel = ActiveDatabase.RootFolder.Object("blast2", fpObjectTypeExcelWorkbook) With oExcel.Add("data", fpObjectTypeExcelDataLink) .YComponent = "tir1!C5" .YLineByLine = True '.Evaluate .Update End With
-
AutorBeiträge
- Du musst angemeldet sein, um auf dieses Thema antworten zu können.