How to add upload excel file and insert into SQL Compact Edition

[Guest]

Hi guys,

As mentioned earlier, I'm coding a barcode scanning system for a Windows CE
5.0 based barcode scanner (actually it's more than a scanner), and I'm
thinking of uploading excel file through various medium and insert/update the
targetted table in SQL Compact Edition, can anyone tell me how should I
achieve that?

Also, I would like to be able to export the desired information from SQL
Compact Edition to Excel spreadsheet too. Would appreciate if any of you have
experience dealing with this and try to share with me the idea and ways of
doing them.

It's very exciting to get it work and play around with it =)

P/S: I'm developing it using Visual Studio 2005 in VB and using SQL Server
2005 Compact Edition (I think I'm just telling something you have already
know =p)


Thanks.

Regards,
Jenson

 

[RDub]

Jenson

I have learned Excel is a **VERY** flexible tool that can tolerate many
different kinds of text file formats. The secret is to be consistent. I
routinely export CSV text files with an .XLS extension that Excel eats as
though it were in an Excel native format. I also routinely export HTML
formatted tables (with headers, hyperlinks, borders and other text
formatting) with an .XLS extension that (from the users point of view) Excel
also treats as its own.

You should not have any problem "Fooling" your users to think you are
exporting excel files, when in fact you are just building nicely formatted
text files with an Excel extension. The vast majority of my customers
haven't a clue that the files they are producing from my app is not really
an Excel file. Even if they did know it was not really an Excel file, they
could care less, as long as they can work with the data once exported.

Ron W

 

[Guest]

Hey Ron,

Brilliant idea, nice experience sharing from you =) I'll work in that way
and check the outcome.

One question, do you ever import data from Excel file into SQL 2005 Compact
Edition in a mobile device?

Thanks.

Regards,
Jenson

 

[RDub]

Nope, never had to go from Excel to SqlCe. Sorry :-(

Our app creates an empty SqlCe database on initial startup, then the user
collects data (via barcode) that we eventually export to Excel, CSV, Sql
2005, or whatever.

Ron W

 

[Guest]

Hi Ron,

It's ok =)

I'll try to get my way there though it's a bit harder but I'll see how it
goes >.<"

Thanks.

Regards,
Jenson