- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
I need to put a bunch of old databases into excel spreadsheet format
Posted on 8/5/22 at 7:27 pm
Posted on 8/5/22 at 7:27 pm
Is there anyway to do this other than manually? About 10,000 people with address or so. is there a program or service that does this cheap
5
Posted on 8/5/22 at 8:04 pm to TutHillTiger
Is it a flatfile? Have you tried to the Import function (data tab) in excel?
Posted on 8/5/22 at 8:06 pm to TutHillTiger
Copy/Paste?
Export then import?
Export then import?
Posted on 8/6/22 at 12:39 am to TutHillTiger
What database engine is the data housed in? Some SQL editors have a function to dump results into a .csv. You can also probably find a free ETL tool to export the data to .csv (maybe even directly to Excel).
Posted on 8/6/22 at 7:52 am to TutHillTiger
Were the old datasets created by the same program(s) ? If so use that particular program (s) to export file to the lowest common denominator such as a CSV file or a text or tab delimited file.
If you don’t have access to the original program(s) but you can view the particular data just using a text editor you may have to just do a lot or some cleanup and then import into the varied data sets excel.
LINK https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files
If you don’t have access to the original program(s) but you can view the particular data just using a text editor you may have to just do a lot or some cleanup and then import into the varied data sets excel.
LINK https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News