Using sqlcompact with how excel-dna

Question

when I use sqlcompact in excel-dna,At sqlceca40.dll I could not packed xll.So I my excel.xll is not work.

score 1 · Answer 1 · answered Jan 14 '19 at 22:54

1

This is not a supported scenario by ExcelDnaPack at the moment.

ExcelDnaPack only supports packing of .NET assemblies (a.k.a. managed DLLs). sqlceca40.dll is a Win32 DLL... Therefore you won't be able to pack that DLL in your XLL using ExcelDnaPack.

You could use alternative approaches to embed the sqlceca40.dll into your add-in assembly using a tool such as Fody.Costura, for example, as this example in SO shows.

answered Jan 14 '19 at 22:54

C. Augusto Proiete

24,684
2
63
91

Thank you very much,I take away sqlcompact.I use file replace it,to cache my data. – 牛慧升 Jan 15 '19 at 01:50

Using sqlcompact with how excel-dna

1 Answers1

Linked