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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access 2000 Transferspreadsheet problem
Just tried resorting to a backup of the database backend and renaming the column headings in Excel to what the database was expecting them to be and it seems to be working, so i'll probably have to do some code that opens the files up and renames before it tries importing them.- sorberec
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access 2000 Transferspreadsheet problem
Hi all, I maintain a small Access 2000 database for one region of my company that imports data extracts from several systems from which to produce local management reports. The extracts are all Excel files and I've been using Transferspreadsheet to import the files into temporary tables. This...- sorberec
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
