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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Set of Excel Sheets to CSV

Status
Not open for further replies.
mmogul

mmogul

IS-IT--Management
Dec 1, 2003
218
US
I am having some problems uploading spreadsheets into Access (see thread705-1498260). As alternative, I think uploading csv files will work.

Need some ideas how to create code to convert an Excel file to csv programmatically.
 
Sort by date Sort by votes
Have a look at the Workbook.SaveAs method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
366
Viswa.R
Viswa.R
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
485
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
410
Moss100
Moss100
Moss100
  • Locked
  • Question
Convert Single Line Address to Multi Line Address 2
Replies
9
Views
321
Moss100
Moss100
Candiman421
  • Locked
  • Question
How to Set Horizontal Alignment in Excel for (Range/Cell)
Replies
0
Views
658
Candiman421
Candiman421

Part and Inventory Search

Sponsor

Back
Top