Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel

Status
Not open for further replies.
fergmj

fergmj

Programmer
Feb 21, 2001
276
US
I am trying to create files and get files in excel format through my VB app. Can anyone tell me the file format? I don't want to start Excel, i just want to create database files in .xls format that I can later open in Excel if I need to.

Thanks

fergmj
 
Sort by date Sort by votes
Can you use CSV files instead? A lot easier to format if all you are saving is data.
 
Upvote 0 Downvote
Can you explain what you mean? I could save it with any extension, but I am looking for the way I need to write the information to the file (the format).

Thanks

fergmj
 
Upvote 0 Downvote
.CSV files are comma-delimited text files.

The format is simply the fields seperated by commas with a carraige return between records.

Excel usually is the default viewer for csv files. Although they can be viewed in Notepad. If you open an Excel worksheet, save it in csv format and open it in Notepad you will see how to format it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
220
Swi
Swi
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
505
strongm
strongm
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
788
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
198
Niki_S
Niki_S
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
312
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top