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

Importing csv file into Access table

Status
Not open for further replies.
longmot

longmot

Programmer
Joined
Apr 22, 2002
Messages
11
Location
GB
Any ideas on how I can go about importing a csv file into an access 97 database by calling the routine from excel (2000)?

I can populate the access table from an xls file via an excel macro but having trouble with the csv file which has too many rows for excel.

 
Sort by date Sort by votes
amazingly enough a similar question was asked and answered in thread181-504232 almost simultaneously.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question Question
Populate access table from excel
Replies
6
Views
6K
OCM
OCM
renigar
  • Locked
  • Question Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
A
  • Locked
  • Question Question
Print Table attachment
Replies
2
Views
517
andre.meyer
A
ameedoo3000
  • Locked
  • Question Question
Clear all table contents without deleting records
Replies
15
Views
2K
ameedoo3000
ameedoo3000
renigar
  • Locked
  • Question Question
Access VBA Syntax Error
Replies
5
Views
5K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top